Skip to content

Registered aircraft · 630

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-11-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-11-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-11-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-11-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-11-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-11-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N6604VKidd Clifford L · Monahans, TXS/N 30267 N6605VWaller Earl D · Wyoming, DEBuilt 1970 · S/N 30280 N6607VGlovier George G · Pocomoke City, MDBuilt 1970 · S/N 30262 N6622VBetts Miley · Highlands Ranch, COBuilt 1970 · S/N 30270 N6624VDahle Jeffrey R · Ashland, ORBuilt 1970 · S/N 31008 N6625VHarais James W · Novato, CABuilt 1970 · S/N 30285 N6632VKlamecki Alan P · Phoenix, AZBuilt 1970 · S/N 30300 N6635VBerger Aerospace LLC · Tomball, TXS/N 30302 N6636VMoss Herman D · Centreville, VABuilt 1970 · S/N 32-32 N6639VWaiwood Michael · Strongsville, OHBuilt 1970 · S/N 30298 N6642VCasey Joseph · Buffalo, WYBuilt 1970 · S/N 30297 N6643VSullivan Hal N Administrator · Paducah, KYBuilt 1970 · S/N 30283 N6644VHeminger Rex A · Colleyville, TXBuilt 1970 · S/N 30281 N6645VBrown Christopher C · Sheridan, WYBuilt 1970 · S/N 30309 N6646VBelush Richard · Columbus, INBuilt 1970 · S/N 30292 N6650VHarris Willis J · Letts, IABuilt 1966 · S/N 30001 N6651VDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1966 · S/N 30003 N6652VLaughlin David E · Rapid City, SDS/N 30005 N6662VOlson Larry L · Timmonsville, SCBuilt 1967 · S/N 30026 N6665VBetts Miley F · Highlands Ranch, COBuilt 1967 · S/N 30035 N666RREllis James F · Culver City, CABuilt 1973 · S/N 74-30632 N666RSLoney James A Trustee · West Chesterfield, NHBuilt 1979 · S/N 79-30936 N666VSouthwest Viking LLC · Anthem, AZBuilt 1979 · S/N 79-31154 N6670VCollum Aviation LLC · Milton, FLS/N 30021 N6675VBrazier Glen A · Greenbush, MNBuilt 1967 · S/N 30033 N6677VFandrich Abraham L · Clancy, MTS/N 30020 N6685VHeirborne LLC · Kansas City, MOS/N 30041 N6686VRegistered aircraftBuilt 1967 · S/N 30050 N6687VOsterberg Douglas L · Neenah, WIBuilt 1967 · S/N 30029 N6688VBesch Marvin Eugene II · Redmond, WABuilt 1967 · S/N 30017 N6689VSchafer Daniel B J · Plainview, TXBuilt 1967 · S/N 30039 N6694VNieting James · Minnetonka, MNBuilt 1967 · S/N 30012 N6696VMccollough William B · Murrells Inlet, SCS/N 30008 N6697VCleveland Lorne T · Tyler, TXS/N 30006 N6698VHeberlein Ronald E · Wilsonville, ORBuilt 1966 · S/N 30004 N66HSAlbertson Jon E · Helena, MTBuilt 1973 · S/N 73-30595 N6703VVanias Polychronis · Leroy, MIBuilt 1970 · S/N 30282 N6706VThompson Timothy · Prosser, WAS/N 30332 N6708VAircraft Restoration Service Enhancements LLC · Mesa, AZBuilt 1970 · S/N 31011 N6709VBlanton Keith O · Collinsville, OKBuilt 1970 · S/N 30310 N6712VBainer Kyle W · Cottage Grove, WIBuilt 1970 · S/N 30307 N678MJPiasa LLC · Pacific, MOBuilt 1979 · S/N 79-30941 N67WDWatson Frank · Canton, PABuilt 1966 · S/N 30015 N68DSkaggs Randall D · Sacramento, CABuilt 1973 · S/N 74-31072 N68FJBurns James A · Madison, WIBuilt 1973 · S/N 73-30578 N68TRNaim Danial Shelby · Iowa Park, TXBuilt 1975 · S/N 75-30749 N69JWWarrior Aviation LLC · Dollar Bay, MIBuilt 1972 · S/N 31036 N711LACrosby David J · Potomac, MDBuilt 1971 · S/N 30411 N711LJIvie Calvin · Roanoke, TXS/N 32-17 N712SREsplin Clyde D · Ontario, ORS/N 30106

Back to AD 87-11-01 R1