Skip to content

Registered aircraft · 20,483

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:84-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:84-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:84-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:84-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:84-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:84-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.

N2685XWorden Andrew · Burlington, COS/N 18255311 N2686FKing Cara Jean · Deland, FLBuilt 1965 · S/N 18256786 N2686QLines Daniel R · Roseburg, ORBuilt 1966 · S/N 18257886 N2687FT Air LLC · Columbia Falls, MTBuilt 1965 · S/N 18256787 N2687LA R Preston Holdings LLC · Ontario, NYBuilt 1998 · S/N 18280314 N2687QKnorr John Lee · Puposky, MNBuilt 1966 · S/N 18257887 N2687RSpangler Keith · Monroeville, INBuilt 1967 · S/N 18258387 N2688FWagosh Aviation LLC · Flagstaff, AZBuilt 1965 · S/N 18256788 N2688RShaw Thomas B · Hobbs, NMBuilt 1967 · S/N 18258388 N2689JFinley Taylor J · Colby, KSBuilt 1979 · S/N T18803497T N2689QKirschke John K · Seneca Falls, NYBuilt 1966 · S/N 18257889 N2689RMortensen Mark S · Hamilton, MTBuilt 1967 · S/N 18258389 N268CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283018 N268DLCrenshaw Robert L · Goldsboro, NCBuilt 1969 · S/N P206-0570 N268JCShaw Melvin · Annapolis, MDBuilt 1978 · S/N R18200213 N268MERegistered aircraftBuilt 2000 · S/N 18280776 N268TZHague Robert A · Rogers, ARBuilt 2020 · S/N 18283108 N26905Indgjer Lawrence D · Pueblo, COS/N 18051354 N2690CEdwards Zachary · Sylmar, CABuilt 1978 · S/N R18200214 N2690FStephenson Casey H · Assaria, KSBuilt 1965 · S/N 18256790 N2690GFerkin Air LLC · Caldwell, IDBuilt 1959 · S/N 51990 N2690JDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N T18803498T N2690RSchleck Scott A · West Concord, MNBuilt 1967 · S/N 18258390 N2690XWestern Nebraska Community College · Scottsbluff, NES/N P2060190 N2690YSmith Joshua B · Kenai, AKS/N 18051190 N2691GPulaski Airport Rental LLC · Denmark, WIBuilt 1959 · S/N 51991 N2691QEw Aircraft LLC · Manhattan, MTBuilt 1966 · S/N 18257891 N2691RLongsview Holdings LLC · Lewes, DEBuilt 1967 · S/N 18258391 N2691ZHoppert Barry E · Merritt Island, FLBuilt 1964 · S/N 1850691 N2692CStewart Chalmous · New London, NCS/N R18200215 N2692GPolhemus John W Jr · Bowie, TXBuilt 1959 · S/N 51992 N2692QHill Jonathan Troy · Taylorsville, KYBuilt 1966 · S/N 18257892 N2692ROliver Craig J · Orion, MIBuilt 1967 · S/N 18258392 N2693R15 Rides LLC · Manteo, NCBuilt 1967 · S/N 18258393 N2694QMiller William A Jr · Okeechobee, FLBuilt 1966 · S/N 18257894 N2695GBackcountry Guys LLC · Prescott, AZBuilt 1959 · S/N 51995 N2695QKirbco Aviation LLC · Doniphan, MOS/N 18257895 N2695RAccardo Paul A · Zwolle, LABuilt 1967 · S/N 18258395 N2696CUnited States Air Force · Peterson Afb, COBuilt 1978 · S/N R18200218 N2696QKlauber Gerald · Lake City, FLBuilt 1966 · S/N 18257896 N2696YD'Anna Michael Joseph · Durango, COBuilt 1962 · S/N 18051196 N2697KPrince John C III · Frierson, LABuilt 1979 · S/N 18053038 N2697RMaring Matthew D · Westley, CAS/N 18258397 N2698GPeterson Floyd M · Lago Vista, TXBuilt 1959 · S/N 51998 N2698QButler John L · Omak, WABuilt 1966 · S/N 18257898 N2698RWeishaupt Louis R · Mackinaw, ILBuilt 1967 · S/N 18258398 N2698XHall Clinton Arthur Jr · Klamath Falls, ORBuilt 1998 · S/N 18280318 N2699FRegistration Pending · Jonesboro, ARRegistration pendingBuilt 1966 · S/N 18256799 N2699XAir Controls Billings Inc · Billings, MTBuilt 1966 · S/N P206-0199 N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546

Back to AD 84-10-01 R1