Skip to content

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N6687JRio Creek Aviators Ltd · Casco, WIBuilt 1968 · S/N 28-24377 N6687WHolland William A · Brownwood, TXBuilt 1965 · S/N 28-20794 N6688WArkansas Air Expeditions And Instruction LLC · Greenbrier, ARBuilt 1965 · S/N 28-20795 N6689WStoll Jared M · Burnt Hills, NYBuilt 1965 · S/N 28-20796 N6690JJones Michael A · Chateaugay, NYBuilt 1968 · S/N 28-24380 N6691WN6691w LLC · Nazareth, PABuilt 1965 · S/N 28-20799 N6693JOgrady Thomas · Franklin Square, NYS/N 28-24385 N6694JStegemoller Adam Dean · Lewisville, TXBuilt 1968 · S/N 28-24387 N6694WKhan Mohammed Sabir K · Sugar Land, TXBuilt 1965 · S/N 28-20802 N6695JMorgan Jonathan · East Troy, WIS/N 28-24388 N6695WMeyers Chris · Andrews, TXS/N 28-20804 N6696JTattersall Stewart Trustee · Minden, NVBuilt 1968 · S/N 28-24389 N6697JGlenn Larry W · Bunn, NCBuilt 1968 · S/N 28-24390 N6699JRegistration Pending · Loup City, NERegistration pendingBuilt 1968 · S/N 28-24393 N66GNMoye Brian C · Naples, FLBuilt 1969 · S/N 28-5717 N6701JJones Bob J Trustee · Littleton, COBuilt 1968 · S/N 28-24395 N6702JWaldron Michelle M · Saranac, NYBuilt 1968 · S/N 28-24397 N6705JDuncan William E · Troy, IDBuilt 1968 · S/N 28-24400 N6711JFirecrest LLC · Holly Springs, MSBuilt 1968 · S/N 28-24408 N6711WBrinkman Michael R · Cleveland, TNBuilt 1965 · S/N 28-20824 N6712JF & F Flying Service Inc · Springfield, VAS/N 28-24410 N6714WFriend Henry H · Hibbs, PABuilt 1965 · S/N 28-20827 N6716WSan Diego Community College District · San Diego, CABuilt 1965 · S/N 28-20829 N6717WFieri Douglas J · La Verne, CABuilt 1965 · S/N 28-20830 N6718JWandro Nicholas John · Norman, OKBuilt 1968 · S/N 28-24420 N6718WMorris Mark · Floral City, FLBuilt 1965 · S/N 28-20831 N6719WPennington Carey L · Tacoma, WABuilt 1965 · S/N 28-20832 N6720JRgi Industry Inc DBA · Norman, OKBuilt 1968 · S/N 28-24424 N6721JLeduc Marquez Ramon · Santa Isabel, PRBuilt 1968 · S/N 28-24425 N6722JPlanenutz LLC · Deland, FLS/N 28-24427 N6722WTurnquest Alexis · West Valley City, UTS/N 28-20836 N6723WWignall Brett T · Jasper, TXBuilt 1965 · S/N 28-20837 N6724JDisabato Anthony · Chicago, ILBuilt 1968 · S/N 28-24430 N6724WHughes Jeffrey A · Wrightsville Beach, NCBuilt 1965 · S/N 28-20838 N6725JBrookeridge Eagles LLC · Downers Grove, ILS/N 28-24432 N6727JS&S Piper · Tipton, CAS/N 28-24435 N6727WCherokee Aviation LLC · Kalispell, MTBuilt 1965 · S/N 28-20842 N6728WFifteen Hundred Hours LLC · Broken Arrow, OKBuilt 1965 · S/N 28-20843 N672FLD J Aero LLC · Churchville, NYBuilt 1971 · S/N 287125599 N6730JDietz Craig S · Grants Pass, ORS/N 28-24439 N6730WPrucha Derek L · Hideaway, TXBuilt 1965 · S/N 28-20846 N6731JHensley Douglas S · Newland, NCBuilt 1968 · S/N 28-24826 N6732JSchool Of Missionary Aviation Technology · Ionia, MIS/N 28-24443 N6732WOhlstein Michael R · Glen Head, NYBuilt 1965 · S/N 28-20848 N6733FMarianas Air Transfer Inc · Saipan, MPS/N 28-7725077 N6733JRedman Cory S · Villa Rica, GABuilt 1968 · S/N 28-24444 N6734JApex Airmotive LLC · Frisco, TXBuilt 1966 · S/N 28-20850 N6735WRegistration Pending · Parsons, KSRegistration pendingBuilt 1965 · S/N 28-20854 N6736JJames Roderick V · Boise, IDBuilt 1968 · S/N 28-24447 N6736WVan Der Linden David R · Sweetwater, TNBuilt 1965 · S/N 28-20855

Back to AD 96-10-01 R1