Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N7050GAircraft Management Group Inc · Honolulu, HIBuilt 1969 · S/N 17258750 N7050QMindy Limited LLC · Muscatine, IABuilt 1972 · S/N 17260350 N7051GWein Greggory J · Convoy, OHBuilt 1969 · S/N 17258751 N7051QBright Flight Aviation Inc · Jacksonville, FLBuilt 1972 · S/N 17260351 N7051TWeems James M · Paris, TXS/N 46651 N7052GG&H Aviation · Louisville, KYBuilt 1969 · S/N 17258752 N7052QHoloman T Michael · New Smyrna Beach, FLBuilt 1972 · S/N 17260352 N7052THurst Jon M · Paw Paw, MIBuilt 1959 · S/N 46652 N7053APearsall Timothy R · Rexford, NYBuilt 1956 · S/N 29153 N7053GSpare Change Enterprises LLC · Atlantic, IABuilt 1969 · S/N 17258753 N7053QCabrie Aviation Inc · Charlotte, NCBuilt 1972 · S/N 17260353 N70541Cl Finney Aviation LLC · Benton, KSBuilt 1969 · S/N 17258757 N7054AOtt Rex A · Burlington, IABuilt 1956 · S/N 29154 N7055QSeagraves Brad J · Rockwell, NCBuilt 1972 · S/N 17260355 N7056QFleeman Joseph R · Lawrenceburg, TNBuilt 1972 · S/N 17260356 N7056THeinke John R · Paradise, CABuilt 1958 · S/N 46656 N7057QMindy Limited LLC · Muscatine, IAS/N 17260357 N7058GDc Aerial Photos Inc · Fredericksburg, VABuilt 1969 · S/N 17258758 N70597Rodriguez Hulises · Chula Vista, CABuilt 1976 · S/N 17267223 N7059AWebster Mark Lawrence · Frankston, TXBuilt 1956 · S/N 29159 N7059GFrank Todd E · Corsicana, TXBuilt 1969 · S/N 17258759 N7059TBrommer Roger A · Lino Lakes, MNBuilt 1959 · S/N 46659 N705FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13073 N705JAFrl Flying LLC · Seattle, WABuilt 2006 · S/N 172S10255 N705LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11426 N705UChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12628 N7060AWalker Jonathan S · Council Bluffs, IABuilt 1956 · S/N 29160 N7060QPilot In Command Academy Inc · Miami, FLBuilt 1972 · S/N 17260360 N7061QMccutcheon Henry C · Frankfort, KYBuilt 1972 · S/N 17260361 N7062GNorthwoods Aviation LLC · Eagle River, WIS/N 17258762 N7062TJardd Inc · Lorain, OHBuilt 1959 · S/N 46662 N7063ASexton Forest · Eagle Point, ORBuilt 1956 · S/N 29163 N7063GL A H Eickhoff Farms Inc · Falls City, NEBuilt 1969 · S/N 17258763 N7063QCarver Clarence K · Lutz, FLS/N 17260363 N7063TMorris Coady C · Russell, KSS/N 46663 N7064ASelby Joshua F · Condon, ORBuilt 1956 · S/N 29164 N7065AJahnke Michael D · Wichita, KSBuilt 1956 · S/N 29165 N7065GAden David L · Keenesburg, COBuilt 1969 · S/N 17258765 N7065TRegistered aircraftBuilt 1959 · S/N 46665 N7066ANewton Consulting & Engineering Inc · Tucson, AZBuilt 1956 · S/N 29166 N7066GSwindle Don K · Collinsville, TXBuilt 1969 · S/N 17258766 N7067AWhitemire Jospeh A · Soddy Daisy, TNBuilt 1956 · S/N 29167 N7067GAngelle Kelli R · New Roads, LABuilt 1969 · S/N 17258767 N7067TSmith Roy Harold · Whiteville, NCBuilt 1959 · S/N 46667 N7068AMcdonald Ronald B · Arcadia, FLBuilt 1956 · S/N 29168 N7068QWestwind Aviation Inc · Bremerton, WABuilt 1972 · S/N 17260368 N7069GAjf Enterprises LLC · Des Moines, IABuilt 1969 · S/N 17258769 N7069QFlakker Michael E · Gold Hill, NCS/N 17260369 N7069THovey Terry W · Rogue River, ORBuilt 1959 · S/N 46669 N706DAFlycarolina LLC · Charlotte, NCBuilt 1980 · S/N 17274339

Back to AD 90-06-03 R1