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.

N828YLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268168 N8290BSchooman Clarence G · Marion, TXBuilt 1957 · S/N 36090 N8290LPretty Plane LLC · Nixa, MOBuilt 1967 · S/N 17256490 N8291ERangers Flying Club Inc · Eden Prairie, MNBuilt 1979 · S/N 17272177 N8291LUsglap LLC · Fort Morgan, COBuilt 1967 · S/N 17256491 N8291UBarnett William M · Rolla, MOBuilt 1964 · S/N 17252191 N8291XChandler Christopher G · Cooperstown, NYS/N 17248791 N8292Gulf Coast Helicopters Inc · Pearland, TXBuilt 1997 · S/N 17280048 N8292BEagle Eye Aerial Imaging LLC · Chagrin Falls, OHS/N 36092 N8292EP&N Corp · Marion, IAS/N 17272178 N8292LBrown Troy M · Austin, TXBuilt 1967 · S/N 17256492 N8292URettkowski Brady A · Hermiston, ORBuilt 1964 · S/N 17252192 N8292XHeadings Daniel E · Salem, ORBuilt 1961 · S/N 17248792 N8293EFiorini Anthony Wayne · Tuttle, OKBuilt 1979 · S/N 17272179 N8294XFranco Stephen B · Chicago, ILBuilt 1961 · S/N 17248794 N8295BSkywriters Inc · Ferndale, WABuilt 1957 · S/N 36095 N8295EFrump Leasing Inc · Newburgh Heights, OHS/N 17272181 N8295UCrawfish Co LLC · Starkville, MSBuilt 1964 · S/N 17252195 N8296EMosbach Rene A · Sandia, TXBuilt 1979 · S/N 17272182 N8297BSchler Joseph B · Reno, NVBuilt 1957 · S/N 36097 N8297EConaway Scott J · Traverse City, MIBuilt 1979 · S/N 17272183 N8297UMcburney Richard O · Hudson, NCBuilt 1964 · S/N 17252197 N8298EAberdeen Flying Service · Aberdeen, SDBuilt 1979 · S/N 17272184 N8299BJohnston Keith G · Honolulu, HIBuilt 1951 · S/N 36099 N8299ELondon Corbin Airport Board · London, KYBuilt 1979 · S/N 17272185 N8299XBeail Herschel D · Quincy, CAS/N 17248799 N829AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13533 N829BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280951 N829EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12837 N829FSPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1999 · S/N 17280795 N82EPPosav Holdings LLC · Zephyrhills, FLBuilt 1978 · S/N 17271353 N82LTRegistered aircraftBuilt 2005 · S/N 172S9913 N82MHRainier Flight Service LLC · Renton, WABuilt 2023 · S/N 172S13002 N8300BMonger Kenneth R · Bella Vista, ARBuilt 1957 · S/N 36100 N8300UFrisby Richard V · Fredericksburg, VABuilt 1964 · S/N 17252200 N8301UN8301u LLC · White Springs, FLBuilt 1964 · S/N 17252201 N8301XLindeman Rusty · D Hanis, TXBuilt 1961 · S/N 17248801 N8302XManley Stephen Edward · Carrabelle, FLBuilt 1961 · S/N 17248802 N8303BBack Jason M · Poolville, TXBuilt 1957 · S/N 36103 N8304BWarzecha Kathy A · Sauk Rapids, MNBuilt 1957 · S/N 36104 N8304XAeschliman Arlie W · Tribune, KSBuilt 1961 · S/N 17248804 N8305BHansen Mark A · Savannah, GABuilt 1957 · S/N 36105 N8305USkyhawk Leasing LLC · Port Huron, MIBuilt 1964 · S/N 17252205 N8306BCoopsair LLC · Saint Petersburg, FLS/N 36106 N8307BRogers Eric M · Cascade, IDBuilt 1957 · S/N 36107 N8308BBerg Timothy J · Neenah, WIS/N 36108 N830KXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2011 · S/N 172S11106 N830MAFlying Technologies LLC · Wilmington, DEBuilt 2001 · S/N 172S8954 N830TNPrianti Paul J · Rockaway, NYBuilt 1972 · S/N 17260881 N8310UUnderwood Michael D II · Piney Flats, TNS/N 17252210

Back to AD 90-06-03 R1