Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N8236PLeary Patrick W · Lewistown, MTBuilt 1963 · S/N 24-3490 N8237CKieszkowski Joseph S · Stilwell, KSFirst renewal noticeBuilt 1954 · S/N 22-2323 N8237PNarveson Kristian · Pueblo West, COBuilt 1963 · S/N 24-3491 N8239P3so II LLC · Louisville, KYBuilt 1963 · S/N 24-3493 N8239YMurray Coy L · Guntersville, ALBuilt 1966 · S/N 30-1365 N823ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496548 N8240CLewis Jonathan · Hadley, MABuilt 1954 · S/N 22-2326 N8241PRegistered aircraftBuilt 1963 · S/N 24-3495 N8242PLake Donald T · Green Valley, AZFirst renewal noticeBuilt 1963 · S/N 24-3496 N8243PMountain Mooney Inc · Idaho Falls, IDS/N 24-3497 N8243YHampton Brent · Edgewood, TXBuilt 1966 · S/N 30-1369 N8244QAeroplane Co LLC · Sylvania, OHBuilt 1980 · S/N 44-8107011 N8244YDow Jeff · Port Hadlock, WABuilt 1965 · S/N 30-917 N8246YVon Gruben Steven E · Bonita Springs, FLBuilt 1967 · S/N 30-1372 N8247GCity Of Stuttgart · Stuttgart, ARBuilt 1973 · S/N 27-7305012 N8247PEldredge Michael J · Modesto, CABuilt 1963 · S/N 24-3501 N8248CFisher Charlton Dru · Houston, TXBuilt 1954 · S/N 22-2334 N8248PArmstrong Kristian Trustee · Airville, PABuilt 1963 · S/N 24-3502 N8249CGifford Steven K · Buskirk, NYBuilt 1954 · S/N 22-2351 N8249POgan Steve G · Pierre, SDBuilt 1963 · S/N 24-3503 N824ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496549 N824AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2026 · S/N 4496625 N8250PSedberry Jason A · Kokomo, INS/N 24-2563 N8250YStoltz Kevin · Locust Grove, GABuilt 1966 · S/N 30-1376 N8251PDefranco Ross A · Los Angeles, CABuilt 1963 · S/N 24-3505 N82526Verbridge Gary · Williamson, NYFirst renewal noticeBuilt 1977 · S/N 25-7756052 N82549Airgo Incorporated · Centralia, ILS/N 44-8107015 N8254EPerfect Agreements Leasing · Trabucco Canyon, CABuilt 1980 · S/N 44-8107014 N8254PRegistered aircraftAssigned, pending cancellationS/N 24-3508 N8254YCrimson Aviation LLC · Helena, MTBuilt 1966 · S/N 30-1380 N8255PKanooth Michael L · Washougal, WABuilt 1963 · S/N 24-3509 N8256PHouse Terry J · Mountain View, ARBuilt 1963 · S/N 24-3233 N8256YPhill-Air Inc · Dover, DEBuilt 1967 · S/N 30-1382 N8257PWipf Ryan C · Mound, MNS/N 24-3510 N8258PThings That Fly LLC · Phoenix, AZBuilt 1963 · S/N 24-3511 N8258YJohnson David C · Chisago City, MNBuilt 1966 · S/N 30-1384 N8259YRyan Ferguson LLC · Sanford, FLBuilt 1966 · S/N 30-1386 N825CRWolken Ralph E · Shady Shores, TXBuilt 1959 · S/N 24-1227 N8261PWarzek Mary Ann · Halfmoon, NYS/N 24-3514 N8261YWilliams Brannon R · Fort Worth, TXBuilt 1966 · S/N 30-1388 N8262YAchamp LLC · Memphis, TNBuilt 1966 · S/N 30-1390 N8263MKent State University · Stow, OHBuilt 1981 · S/N 44-8195026 N82646Downs Ricky R Trustee · Roundup, MTS/N 36-7760127 N8264FRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107027 N8264PChavez Raul M · Comanche, TXBuilt 1963 · S/N 24-3517 N8264YPatterson Casey Paul · Kinston, ALBuilt 1966 · S/N 30-1392 N82656Souther Field Aviation Inc · Americus, GAFirst renewal noticeBuilt 1977 · S/N 36-7760134 N8265PNiemiec Andrew Josephtrustee · Anchorage, AKBuilt 1963 · S/N 24-3518 N8266CPiper 8266c LLC · Indianapolis, INBuilt 1954 · S/N 22-2341 N8266POtto David M · Gig Harbor, WABuilt 1963 · S/N 24-3519

Back to AD 85-02-05 R1