Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N20431Organization Of Black Aerospace Professionals · Westchester, ILBuilt 1972 · S/N 17261283 N20437Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261287 N20439Wilken Virginia · Sequim, WABuilt 1972 · S/N 17261289 N2043QAnderson Michael R · Bedford, INBuilt 1973 · S/N 177RG0443 N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010 N2043YGrierson Robert A · Queen Creek, AZBuilt 1962 · S/N 17249543 N2043ZRobotico Holdings Corp · Roselle, ILBuilt 1963 · S/N 15059843 N20443Walker Martha D · Auburndale, FLBuilt 1972 · S/N 17261291 N20445Norman Chuck DBA · Zanesville, OHBuilt 1972 · S/N 17261293 N20448Delta Echo Whiskey LLC · Apopka, FLBuilt 1982 · S/N R18201923 N2044GSpear Michael J · Sandpoint, IDBuilt 1958 · S/N 51344 N2044QWhite Sound International Ltd · New Smyrna Beach, FLBuilt 1973 · S/N 177RG0444 N2044RMiller Steven Chris · Royse City, TXBuilt 1964 · S/N 18255244 N2044XNc Flyers LLC · Raleigh, NCBuilt 1965 · S/N 18256144 N20451Registration Pending · Swainsboro, GARegistration pendingBuilt 1972 · S/N 17261297 N20452Bay Flying Services LLC · Pinconning, MIBuilt 1972 · S/N 17261298 N20454Rl Aviation LLC · Miami, FLBuilt 1972 · S/N 17261300 N20455Kachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 17261301 N20457Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1972 · S/N 17261303 N2045XOsborne David A · Helotes, TXS/N 18256145 N2045YAir Dakota Flite Inc · Hettinger, NDBuilt 1962 · S/N 17249545 N2045ZBragg J Robert · Cortez, COBuilt 1963 · S/N 15059845 N20463Merritt Daniel D · Graham, WABuilt 1981 · S/N 18053187 N204648231 Tango Enterprises LLC · Guthrie, OKBuilt 1972 · S/N 17261308 N20465C Flyers Inc · Dyersville, IABuilt 1972 · S/N 17261309 N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013 N2046ULegacy Aviation Foundation Inc · Staten Island, NYBuilt 1975 · S/N 150-76961 N20470Dameron Cleveland Forrester · Wicomico Church, VABuilt 1972 · S/N 17261313 N20471Cp Aircraft Leasing LLC · Danville, CABuilt 1972 · S/N 17261314 N20472N20472 LLC · Opa Locka, FLBuilt 1972 · S/N 17261315 N20474Voinovich John · Ogden, UTBuilt 1972 · S/N 17261317 N2047ESeaside Cycles Inc · Johns Island, SCBuilt 1978 · S/N 17271131 N2047GSatina David J · Norton, OHBuilt 1958 · S/N 51347 N2047QMeersma Montgomery D · Atlanta, GABuilt 1973 · S/N 177RG0447 N2047YMohr Jacob Karl · Van Wert, OHBuilt 1962 · S/N 17249547 N2047ZDhall Sanjay · Canton, MIBuilt 1963 · S/N 15059847 N20481Lesage Robert E · Puyallup, WABuilt 1973 · S/N 17261324 N20484North Central Aircraft Sales · Tioga, NDBuilt 1973 · S/N 17261327 N20486Humbert Delmar Alan · Briones, CABuilt 1973 · S/N 17261329 N20487Point To Point Air LLC · Arlington, WAS/N 17261330 N20488Aurora 17 Holdings LLC · Aurora, ORBuilt 1973 · S/N 17261331 N2048GIozia Luz E · Ruidoso, NMS/N 51348 N2048YIron Horse Aviation LLC · Omak, WAS/N 17249548 N20490Aarow Aircraft Leasing LLC · Mcminnville, ORS/N 17261333 N20492Crockett Richard S · Saint George, UTS/N R1722463 N20494Aviation Group Jmj Inc · Callahan, FLS/N 17261337 N20496Hess Garrett J · Fullerton, CABuilt 1973 · S/N 17261339 N2049QDdv Equipment Leasing LLC · Cheyenne, WYBuilt 1973 · S/N 177RG0449 N2049XTaylor Stephen A · Benton, KSBuilt 1965 · S/N 18256149 N204CMMorgan Kenneth J · Norridgewock, MEFirst renewal noticeBuilt 1975 · S/N 17265224

Back to AD 87-20-03 R2