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.

N4910DN4910d LLC · Delavan, WIBuilt 1979 · S/N 17272394 N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459 N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395 N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460 N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463 N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464 N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102 N4919GRegistration Pending · Fairbanks, AKRegistration pendingS/N 17273466 N491EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12259 N491SFSnohomish Flying Service Inc · Snohomish, WABuilt 2003 · S/N 172S9565 N491SPLittle Rock Lsa Leasing And Rental LLC · Searcy, ARBuilt 1998 · S/N 172S8032 N491WSDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 172S8305 N4920GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273467 N4921VFrumkin Mark Steven · Pittsburgh, PABuilt 1980 · S/N 172RG0416 N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398 N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469 N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417 N4923DHarrier Aviation LLC · South Saint Paul, MNFirst renewal noticeBuilt 1979 · S/N 17272399 N4925FA S Air LLC · Lantana, FLBuilt 1979 · S/N 17273103 N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472 N4927DGreenville Flight LLC · Greer, SCS/N 17272401 N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676 N492ERWings Over Kauai LLC · Kalaheo, HIS/N 172S8946 N492SFSnohomish Flying Service Inc · Snohomish, WABuilt 1976 · S/N 17268310 N492SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8033 N492WPAngel Aviation Inc · Peoria, AZBuilt 1979 · S/N 17272684 N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482 N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484 N4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420 N493EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12260 N493RMRaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280784 N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881 N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681 N4940GN4940g LLC · Portsmouth, NHS/N 17273487 N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494 N4948GTrece Inc · Adair, OKS/N 17273495 N4949GFalcon Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17273496 N494AMOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17269969 N494EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11602 N494JBD & S Aviation LLC · Spring, TXBuilt 2002 · S/N 172S9099 N494SPInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 172S8035 N494TMDuke Flight Training LLC · Bonnyman, KYBuilt 1975 · S/N 17265022 N494WAFly More Inc · Kawkawlin, MIBuilt 1978 · S/N 17271129 N4950DSimpson Darrell W · Soldotna, AKBuilt 1979 · S/N 17272408 N4951GMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273498 N4952GHighland Rim Aviation LLC · Springfield, TNS/N 17273499 N4953GMcfly LLC · Casper, WYBuilt 1979 · S/N 17273500 N4953VMccreery Aviation Co Inc · Mcallen, TXBuilt 1980 · S/N 172RG0423 N4954GKris Noone Air LLC · Wilmington, DEBuilt 1979 · S/N 17273501 N4955DBerman David M · Charlotte, NCBuilt 1979 · S/N 17272409

Back to AD 90-06-03 R1