Registered aircraft · 54,015

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.

N6829ABaker Elbert W · Beckley, WVBuilt 1956 · S/N 28929 N6829ELay Steven K · New Vienna, OHBuilt 1959 · S/N 56329 N6829XZeegers Jozef · Bellingham, WABuilt 1960 · S/N 47729 N682ADDuncan Brian · Indianapolis, INBuilt 1971 · S/N 15072493 N682APFlipside Aviation LLC · Berthoud, COBuilt 1979 · S/N R182-01072 N68302Fulltron Aviation LLC · Springfield, MOS/N 15282240 N6830ALange Cole K · Oglala, SDBuilt 1956 · S/N 28930 N6830EJackson Thomas M · Florissant, MOBuilt 1960 · S/N 56330 N6830MJ & J Air LLC · Laurel, MSBuilt 1975 · S/N 18263850 N6830RElizalde Carla Zankiz · Estero, FLBuilt 1967 · S/N T210-0230 N6831ASale Reported · Pullman, WASale reportedS/N 28931 N6831HQuarry Jon C · Memphis, TNBuilt 1975 · S/N 17265600 N6831MSouth Beach Adventure Sports LLC · Bald Head Island, NCBuilt 1977 · S/N 21061994 N68323Briggs Jeffery M Trustee · Royal Oak, MIBuilt 1978 · S/N 15282257 N68329Ace Aircraft Leasing Inc · Nazareth, PAS/N 15282261 N6832EStuebner David M · Delanson, NYBuilt 1959 · S/N 56332 N6832GAeronautical Technical Service Inc · Collierville, TNS/N 15072332 N6832RWheeler David G Jr · Chico, CAS/N T210-0232 N6832XOwens Philip A · Maryville, TNBuilt 1960 · S/N 47732 N68332Wings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285326 N68334University Of Michigan Flyers · Ann Arbor, MIBuilt 1978 · S/N 15282265 N6833AChapter 163 Flying Club · Las Vegas, NVBuilt 1956 · S/N 28933 N68342M & S Air Supply Inc DBA · Hawthorne, CABuilt 1978 · S/N 15282269 N68344South Bay International Flight Association Inc · Torrance, CABuilt 1978 · S/N 15282271 N68348Tully Robert · Eighty Four, PABuilt 1978 · S/N 15282275 N68349East Derrick A · Cullman, ALBuilt 1978 · S/N 15282276 N6834FLecompte Kevin J · Lancaster, MABuilt 1966 · S/N 15063434 N6834GRoberts Edwin G · Lake Wales, FLBuilt 1970 · S/N 15072334 N68356Don Davis Aviation Inc · Henderson, KYBuilt 1981 · S/N 15285327 N6835ABaratka Darin W · Phillips, WIBuilt 1956 · S/N 28935 N6835HIowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17265602 N6835MMgadi LLC · Trenton, MIBuilt 1975 · S/N 18263852 N6836ARiner Mark G · Bartlesville, OKBuilt 1956 · S/N 28936 N6836FFoley Anthony · Savannah, GABuilt 1966 · S/N 15063436 N6836GRegistration Pending · Highland, UTRegistration pendingBuilt 1970 · S/N 15072336 N6836XNelson John D · Sonora, CABuilt 1960 · S/N 47736 N6837ANorth Nathan A · Damascus, MDBuilt 1956 · S/N 28937 N6837FSkyberjet LLC · Allen, TXBuilt 1966 · S/N 15063437 N6838EBognar Jeffrey L · Kinnelon, NJBuilt 1959 · S/N 56338 N6839MKulton Jon T · Somonauk, ILBuilt 1975 · S/N 18263854 N6839XCripe Rodney J · Middlebury, INBuilt 1960 · S/N 47739 N683HDFord Dwight M · Gig Harbor, WAS/N 17250499 N683JWLotela Partners LLC · Avon Park, FLBuilt 1980 · S/N 21063982 N68402Space Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 15282284 N6840AMcnaught Scott S · Winlock, WABuilt 1956 · S/N 28940 N6840FBushre David · Janesville, WIBuilt 1966 · S/N 15063440 N6840GMiller Robert L · Tecumseh, MIBuilt 1970 · S/N 15072340 N6840MFlying R Aviation LLC · Trenton, MOBuilt 1975 · S/N 18263855 N6840XDesertshot Inc · El Paso, TXBuilt 1960 · S/N 47740 N68414Wright Duane C · Sanford, FLBuilt 1978 · S/N 15282288

Back to AD 87-20-03 R2