Skip to content

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.

N397DJRickenbach Andreas N · Truckee, CABuilt 1967 · S/N U206-0881 N397MSGregory Wm Broburg Ltd · Minneapolis, MNS/N 21061449 N39806Williams Jeffrey Thomas · Aurora, COS/N 73-30510 N39807Sale Reported · Del Rio, TXSale reportedBuilt 1972 · S/N 73-30492 N39808Coen Brady L · Wiley, COBuilt 1972 · S/N 73-30514 N39813Emde William C · Marina Del Rey, CAS/N 73-30508 N39818Connell Edward A III · Crescent City, FLBuilt 1972 · S/N 73-30511 N39820Benkert Daniel D · Rapid City, SDBuilt 1972 · S/N 73-30512 N39826Chardon Stephen A · Franconia, NHBuilt 1972 · S/N 73-30499 N39839Phillips John C · Gallina, NMBuilt 1972 · S/N 73-30496 N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255 N3983YMalpass William H DBA · Shreveport, LAS/N 21058483 N39841Riggin Flight Service Inc · Madison, SDS/N 30484 N39843Altounian Adam J · Charleston, SCBuilt 1972 · S/N 73-30493 N39844Aero-Spray Inc · Kingfisher, OKBuilt 1972 · S/N 73-30513 N39849Lowe Kenneth E Jr · Wooster, OHBuilt 1972 · S/N 30486 N39856Zollars Byron · Georgetown, TXBuilt 1972 · S/N 73-30490 N39861Hafley Richard D · Big Spring, TXS/N 73-30529 N39862Shipley Steven D · Masterson, TXS/N 73-30527 N39863Peeples Ryan K · Folkston, GABuilt 1973 · S/N 73-30536 N39868Horizon Adventures LLC · Alamogordo, NMBuilt 1973 · S/N 73-30533 N39876Bawden Ronald M · Rough And Ready, CABuilt 1972 · S/N 30455 N39878Beckett Aero LLC · Roy, WABuilt 1973 · S/N 73-30548 N39879Flippen Danny W · Fort Smith, ARBuilt 1973 · S/N 73-30541 N3987GParkhill Scott · Perrysburg, OHBuilt 1967 · S/N U206-0987 N39880Balloon Promotions Inc · Greenwood, MSBuilt 1973 · S/N 73-30551 N39881Hackler Craig J · Parker, COBuilt 1973 · S/N 73-30539 N39882Crites Samuel V · North Liberty, IABuilt 1973 · S/N 73-30552 N39885Hummel Mark H · Wyalusing, PABuilt 1973 · S/N 73-30543 N39889Joplin Samuel K · New Orleans, LABuilt 1973 · S/N 73-31057 N39893Owens Gary W · Palo, IABuilt 1973 · S/N 73-30560 N39896Red Barn Flight LLC · Sauk Rapids, MNBuilt 1973 · S/N 73-30558 N39897Pingston Robert D · Morrice, MIS/N 73-30556 N39899Tolvstad Randy L · Mellette, SDFirst renewal noticeBuilt 1973 · S/N 73-30550 N3989GJsh Farms Inc · Hermiston, ORS/N U206-0989 N3989YSchmitt Rudy · Brookshire, TXBuilt 1964 · S/N 21058489 N398EPJg'S Mallardaire LLC · Benton, ARBuilt 1982 · S/N E-2029 N398LJDakota Heavy Equipment · Fargo, NDBuilt 1988 · S/N EA-471 N398LTHogan William · Deer Lodge, MTBuilt 1964 · S/N D-7406 N398PGeorge Monte C · Ashland, ORBuilt 1966 · S/N 320D0106 N398TWaffensmith Walter L Trustee · Golden Valley, MNBuilt 1976 · S/N E-976 N39907Sale Reported · Elizabeth City, NCSale reported, pending cancellationBuilt 1973 · S/N 73-30553 N3991AJohnson Douglas H · Rockwall, TXBuilt 1970 · S/N CE-315 N3992GFlat Earth LLC · Kalispell, MTS/N U2060992 N3992QWisberg Robert E · Bonners Ferry, IDBuilt 1973 · S/N 18502218 N3994QSchneider Don C · Juneau, AKBuilt 1973 · S/N 18502220 N3994YCrosco LLC · Canton, OHBuilt 1964 · S/N 21058494 N3995AMccoy Keith · Salt Rock, WVBuilt 1978 · S/N 310R1347 N3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCBuilt 1968 · S/N U206-0995 N3999SViking Aviation LLC · Kindred, NDBuilt 1978 · S/N 310R1292

Back to AD 86-13-04 R3