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.

N9702LFlying Dreams One LLC · Louisville, KYBuilt 1986 · S/N 17276600 N9702TStricklin Lance A · Fort Greely, AKS/N 47502 N9703TBlock Douglas · Pearl City, ILBuilt 1960 · S/N 47503 N97045Smith Brandon J · Casselton, NDBuilt 1984 · S/N 17276148 N97055Skaya Aircraft LLC · Kalispell, MTBuilt 1984 · S/N 17276149 N9706QTzafrir Sheffer · Seattle, WABuilt 1975 · S/N 17265784 N9706TStoddard Micah J · Boise, IDBuilt 1960 · S/N 47506 N9706VDagnon Paul A · Apple Valley, MNBuilt 1974 · S/N 17264482 N97075Sopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1984 · S/N 17276152 N9709BPeterson Air LLC · Chisago City, MNBuilt 1981 · S/N 172RG0982 N970LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12040 N970RBBas Part Sales LLC · Greeley, COS/N 17250175 N9710ASky Mobility LLC · Warrington, PABuilt 2006 · S/N 172S10149 N9710BWellnitz Patrick · Whitewater, WIS/N 172RG0983 N9710FAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280017 N9710TTrzynka Dean A · Iron River, WIBuilt 1960 · S/N 47510 N97116N97116 LLC · Hector, MNS/N 17276155 N9713FDhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280018 N97154Poddoubnyi Andrey Alexandrovich · Vista, CABuilt 1984 · S/N 17276160 N9715FPlock Cory J · Southbury, CTBuilt 1997 · S/N 17280030 N97163Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276161 N97172C P Aviation · Santa Paula, CABuilt 1984 · S/N 17276162 N9717BCeruto Jorge · Auburndale, FLBuilt 1981 · S/N 172RG0987 N9717HBullock Linda A · Shawnee, KSFirst renewal noticeBuilt 1975 · S/N 17266331 N9717QRosenberger Gregg J · Keller, TXBuilt 1975 · S/N 17265786 N9717VTco Inc · Stanley, NDBuilt 1974 · S/N 17264484 N9718HDyer Stacey T · Jensen Beach, FLS/N 17266332 N9719VCumbie Curtis F · Fayetteville, ARBuilt 1974 · S/N 17264485 N971KCDenventures Aviation LLC · Wheat Ridge, COBuilt 2000 · S/N 17280971 N971TABanner Aviation LLC · Trabuco Canyon, CABuilt 2002 · S/N 172S9170 N971THSanders Aviation Inc · Jasper, ALBuilt 2023 · S/N 172S12971 N9720VBoobas John P · Nicholson, GABuilt 1974 · S/N 17264486 N9721HFoster Gary P · Anchorage, AKBuilt 1975 · S/N 17266334 N9722HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266335 N9722TFoust Richard W · Minneapolis, KSBuilt 1960 · S/N 47522 N9722VTck Services LLC · Millington, MIBuilt 1974 · S/N 17264488 N9723HFlying Tigers Flight School LLC · Houston, TXBuilt 1975 · S/N 17266336 N9723TLuinstra Lee Vernon · Benton, KSBuilt 1960 · S/N 47523 N9725QWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265787 N9725TAnderas Per R · Green Bay, WIS/N 47525 N97266East Hill Flying Club · Ithaca, NYBuilt 1984 · S/N 17276169 N97269J&L Aviation LLC · Malta, NYBuilt 1984 · S/N 17276170 N9726TBuettner Casey R · Kearney, NES/N 47526 N9727TRogers Bob · Mountain Green, UTBuilt 1960 · S/N 47527 N9727VDills John H · Ione, WABuilt 1974 · S/N 17264492 N9728TBanks Trevor A · Thomaston, GABuilt 1960 · S/N 47528 N9729TGibbs David F · Greenville, NCBuilt 1960 · S/N 47529 N972BBBig Red Buffalo LLC · Hagerman, IDBuilt 2005 · S/N 172S10052 N972DPCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258652 N972FCBlackhawk Holding Corp · Wilmington, DEBuilt 1979 · S/N 17272682

Back to AD 90-06-03 R1