Skip to content

Registered aircraft · 20,687

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.

N739DBMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270451 N739DDRivera Carlos R · Carolina, PRBuilt 1978 · S/N 17270453 N739DEWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17270454 N739DFMorcom Aviation Services Inc DBA · Everett, WABuilt 1978 · S/N 17270455 N739DJKemp Kerm R · Southwest Ranches, FLBuilt 1978 · S/N 17270458 N739DPMoler Darryll M · Mount Orab, OHBuilt 1978 · S/N 17270463 N739DRCenterline Holdings LLC · Belgrade, MTBuilt 1978 · S/N 17270465 N739DTWheelair Inc · Fairfield, CABuilt 1978 · S/N 17270467 N739DWKayo Air Service Inc · Harlingen, TXBuilt 1978 · S/N 17270470 N739DXRegistration Pending · Glendale, CARegistration pendingBuilt 1978 · S/N 17270471 N739DZFerrari Thomas J · Torrance, CABuilt 1978 · S/N 17270473 N739EAVpc Air Inc · Cartersville, GABuilt 1978 · S/N 17270474 N739EFDyberg Mike · Mount Vernon, WABuilt 1978 · S/N 17270479 N739EHDairy Air Inc · Wyoming, PABuilt 1978 · S/N 17270481 N739EKParker Dean · Rawlins, WYS/N 17270483 N739EPLucci Giacinto A · Nashville, MIS/N 17270487 N739ERSmitty 172 LLC · Rockford, MIBuilt 1978 · S/N 17270489 N739ET2035 Holdings LLC · Las Vegas, NVBuilt 1978 · S/N 17270491 N739EUStar Fleet Aviation LLC · New Albany, OHBuilt 1978 · S/N 17270492 N739EYLease Aviation Inc · Waterford, MIFirst renewal noticeBuilt 1978 · S/N 17270496 N739EZLow Flying Angels Inc · Folsom, CABuilt 1978 · S/N 17270497 N739FCAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N 17270500 N739FDHutchinson Johnny M · Blytheville, ARBuilt 1978 · S/N 17270501 N739FGWings Flight Enterprises Inc · Danville, KYBuilt 1978 · S/N 17270504 N739FHR&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270505 N739FMRegistration Pending · Concord, NCRegistration pendingBuilt 1978 · S/N 17270508 N739FNRussell David P · Owensboro, KYBuilt 1978 · S/N 17270509 N739FPTmw Aviation LLC · Portland, ORBuilt 1978 · S/N 17270510 N739FSLindsay Aviation Inc · West Seneca, NYBuilt 1978 · S/N 17270513 N739FTWings Of Her Dreams Aviation LLC · Belton, TXS/N 17270514 N739FU9fu LLC · Anchorage, AKBuilt 1978 · S/N 17270515 N739FYSanford Aircraft LLC · Winter Springs, FLBuilt 1978 · S/N 17270519 N739FZSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17270520 N739GCSavage Dewey M · Newport Beach, CABuilt 1978 · S/N 17270523 N739GDMidwest Trucking Transport Inc · Willowbrook, ILBuilt 1978 · S/N 17270524 N739GEAllnew Enterprises Inc · Scotch Plains, NJFirst renewal noticeBuilt 1978 · S/N 17270525 N739GFDahl Peter · Webster, MNBuilt 1978 · S/N 17270526 N739GGRaptor Aviation LLC · South Saint Paul, MNFirst renewal noticeBuilt 1978 · S/N 17270527 N739GHGreer Stephen R · Rowlett, TXBuilt 1978 · S/N 17270528 N739GQMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270535 N739GSCke Aviation LLC · Marietta, GAS/N 17270537 N739GUKimrey Norman Harold · Springdale, ARBuilt 1978 · S/N 17270539 N739GVQuarter To Two Flying Club Inc · Williamsport, PAS/N 17270540 N739GXMusic City Air LLC · Rogersville, ALBuilt 1978 · S/N 17270542 N739GYRadecki Francis R · Carmichael, CABuilt 1978 · S/N 17270543 N739HCGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1978 · S/N 17270547 N739HDRoseland Dan E · Sonoma, CABuilt 1978 · S/N 17270548 N739HETakai Hiroyasu · San Jose, CABuilt 1978 · S/N 17270549 N739HHAbove And Beyond Aviation LLC · Austin, TXBuilt 1978 · S/N 17270552 N739HKSouthwest Aeronautics Mathematics & Science Acad · Albuquerque, NMBuilt 1978 · S/N 17270554

Back to AD 90-06-03 R1