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.

N6221PLicata Paul Z · Mexico, MOS/N 24-1323 N6222PPacheco Carlos Antonio · Yuma, AZBuilt 1959 · S/N 24-1324 N6223YSeminole Flying & Soaring Inc · Clermont, FLFirst renewal noticeBuilt 1965 · S/N 25-3296 N6224PDattilio Joseph · Wasilla, AKS/N 24-1326 N6225PMcvey Charles D · Merritt Island, FLBuilt 1959 · S/N 24-1327 N6225ZBriner Mark E · Utica, KYBuilt 1963 · S/N 25-273 N6226PHofstetter Fred M · Boerne, TXBuilt 1959 · S/N 24-1328 N6229PA2a Aviation Inc · Simsbury, CTBuilt 1959 · S/N 24-1332 N622BRidley Aircraft & Aviation Services LLC · Gilbert, AZBuilt 1966 · S/N 1341 N622JBSun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 44-7995080 N622KCarr Randal J · Chandler, OKBuilt 1975 · S/N 27-7554088 N622TBPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854091 N6230YRegistration Pending · Chapmansboro, TNRegistration pendingBuilt 1966 · S/N 27-3459 N6235YBeaver Douglas G · Harleysville, PAS/N 27-3467 N6236PHill Scott G · Mcdonough, GABuilt 1959 · S/N 24-1341 N6238YBarding Steven P · Hogansville, GAS/N 27-3470 N6238ZDrake Aerial Enterprises LLC DBA · Genoa, OHBuilt 1960 · S/N 25-289 N6239ZQuickflight LLC · Mazomanie, WIBuilt 1960 · S/N 25-290 N623AFaught Jeffrey R · Bismarck, NDBuilt 1951 · S/N 22-24 N623JNBoard Of Trustees Of Western Michigan University · Battle Creek, MIS/N 4496499 N6240POrtiz Raul D · Fredericksburg, VABuilt 1959 · S/N 24-1345 N6244PSimon Projects LLC · Sebastian, FLBuilt 1959 · S/N 24-1349 N6245PBishop Warren · Iowa City, IABuilt 1959 · S/N 24-1351 N62494Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654019 N62495Gentrys Flying Service LLC · Prattville, ALBuilt 1976 · S/N 277654020 N62498Hogan Michael J · Bonita Springs, FLBuilt 1975 · S/N 27-7654023 N6249PKeller Richard A · Stacy, MNBuilt 1959 · S/N 24-1356 N6249YPapagni Demetrio G · Madera, CAS/N 27-3487 N624ATiffany Connor D · Naknek, AKBuilt 1951 · S/N 22-27 N624EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2024 · S/N 4496577 N624TBBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2020 · S/N 4496512 N62508Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7654029 N6251PPearce Donnie D · Mena, ARBuilt 1959 · S/N 24-1358 N6253YMidwest Air LLC · Hartford, SDS/N 27-3491 N6254PMcphee Michael Andrew · Cherokee, TXBuilt 1959 · S/N 24-1361 N62553Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7654034 N62557Yukon Intermountain Inc · Anchorage, AKBuilt 1976 · S/N 27-7654037 N62564Del Mar College · Corpus Christi, TXBuilt 1976 · S/N 27-7654044 N6256PReilly Thomas J · Happy Valley, ORBuilt 1959 · S/N 24-1363 N6257HFinck Michael · Port Charlotte, FLS/N 277654057 N6257YDavila Rudolfo G · Runge, TXS/N 27-3497 N62593Samco USA LLC · Reno, NVBuilt 1976 · S/N 27-7654071 N62599Raw Enterprises Inc · Lewes, DEBuilt 1976 · S/N 27-7654077 N6259PWyant Dustin Jay · Great Bend, KSBuilt 1959 · S/N 24-1366 N625DEGraham Andrew D · Edmonds, WABuilt 1953 · S/N 22-1679 N625YCMatthews Grover C · Fairborn, OHBuilt 1954 · S/N 23-54 N62607Horizon Aeronautics · Columbia, SCBuilt 1976 · S/N 27-7654083 N6260PLarson Jeffery A Trustee · Marysville, CABuilt 1959 · S/N 24-1368 N6260ZAerial Banners North Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-321 N6261PRice Brent M · Onalaska, WABuilt 1959 · S/N 24-1369

Back to AD 85-02-05 R1