Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N513ZMBullard Aerospace Corp · Boston, MABuilt 1999 · S/N 29-0202 N5140JTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 340-0530 N5141QImagination Publications Inc DBA · Saratoga, WYBuilt 1972 · S/N 21059641 N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851 N5146QJ&G Aero Investments Group LLC · Wilmington, DEBuilt 1972 · S/N 21059646 N5147CMiller Ronald D · Hattiesburg, MSBuilt 1978 · S/N 310R1423 N5147YN5147y LLC · Andover, MNBuilt 2004 · S/N 0848 N514AVDigirolamo Anthony S · Stow, MABuilt 1979 · S/N CE846 N514BKNot For Naught LLC · Wimberley, TXBuilt 1974 · S/N E-514 N514BRJmb Aviation LLC · Iowa City, IABuilt 2004 · S/N 1245 N514CSTomco Stores Ltd · Ruidoso, NMBuilt 1964 · S/N D-7533 N514EDFarris Stephen L · Hickory, NCBuilt 2005 · S/N 1420 N514HRSethi Inderdeep Singh · Tracy, CABuilt 1980 · S/N EA-70 N514KCPerazzola Carl J · Bonaire, GABuilt 1966 · S/N TE-82 N514LPInvader Aviation LLC · Tijeras, NMBuilt 1980 · S/N 414A0507 N514NCHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0514 N514PCParsons Donald E · Clarksville, TNBuilt 1969 · S/N D-8967 N514SGBorland Equipment Leasing LLC · Midland, TXBuilt 2000 · S/N 29-0257 N514SMEleven Eleven Aviation LLC · Rockwall, TXBuilt 2005 · S/N 1303 N514TPactolus Investments LLC · Blounts Creek, NCBuilt 1980 · S/N U20605940 N5150EM & M Aviation Enterprises LLC · Springfield, MOS/N E-3412 N5151JHalverson Mechanical Inc · Ogden, UTBuilt 1975 · S/N 340-0541 N5151QNotsa LLC · Morrison, COBuilt 1972 · S/N 21059651 N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289 N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656 N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100 N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292 N5159RBackcountry Adventures LLC · Big Lake, AKBuilt 1976 · S/N 18503011 N515DCmmk LLC · Talent, ORBuilt 1980 · S/N 340A-1022 N515FVSlowmow Inc · Palestine, TXS/N 414-0410 N515MAAdams Scott M · Seabrook, TXS/N 1851070 N515PDSeals Welding & Fabircating Inc · Oxford, ALBuilt 1990 · S/N CE-1532 N515RJFroehlich Franz M · Oceanside, CABuilt 1983 · S/N EA-357 N515RRHangar 49 Ltd · Wilmington, DEBuilt 1987 · S/N 4608080 N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235 N515STQ&A Holdings LLC · Elkridge, MDBuilt 1971 · S/N 414-0169 N515TGMilton Steven Pichon · Houston, TXBuilt 1994 · S/N EA-570 N5160JZemnickas William V · Metamora, MIS/N 340-0550 N5161USkyler Aviation · San Diego, CABuilt 1964 · S/N 206-0161 N5163JQuantie Harold · Locust Grove, OKBuilt 1975 · S/N 340-0553 N5165JPeak Wings LLC · Missoula, MTBuilt 1975 · S/N 340-0555 N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294 N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004 N516CR516 Ontario Capital Holdings LLC · Hartland, WIBuilt 2005 · S/N 1309 N516EVAerofly Procurement LLC · Owasso, OKBuilt 2005 · S/N 1445 N516MAMidwest Wings LLC · Onalaska, WIBuilt 2017 · S/N E-4099 N516WClearwater Holding LLC · Parkersburg, WVBuilt 1975 · S/N D9744 N5171VLisenbey Edward · Caldwell, IDS/N 21060846 N5172RWaterhouse Roy Todd · Mccall, IDBuilt 1976 · S/N 18503012 N5173UKnutson Wayne R · Tioga, NDBuilt 1964 · S/N 206-0173

Back to AD 86-13-04 R3