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.

N4027PAg Air Squadron One LLC · Saint Joseph, ILBuilt 1958 · S/N 23-1502 N40288Pacific Fleet Aviation LLC · Rochester, NYBuilt 1973 · S/N 27-7305104 N4032PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1508 N4034PKoenig William J · Benedict, MDS/N 23-1510 N4036PFiegel Donald H · Ward, ARBuilt 1958 · S/N 23-1512 N40372Gajewski Lillia M · Billings, MTBuilt 1973 · S/N 27-7305135 N40399Aviation Academy LLC · Wichita, KSBuilt 1973 · S/N 27-7305163 N4039PPetersen Clayton L · Albert Lea, MNBuilt 1958 · S/N 23-1516 N40400R & P Aero LLC · Grand Haven, MIBuilt 1973 · S/N 27-7305164 N40439Usoarflorida LLC · Fort Myers, FLBuilt 1971 · S/N 39-94 N40453Aerospace Trust Management LLC Trustee · Wilmington, DES/N 27-7305166 N40454Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 27-7305167 N40464Pavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305181 N40465Bartow Municipal Airport Development Authority · Bartow, FLBuilt 1973 · S/N 27-7305182 N4046PMeyer Edward E · Bolingbrook, ILBuilt 1958 · S/N 23-1523 N40471Hamilton Christopher C · Sonoita, AZBuilt 1973 · S/N 27-7305189 N404CHNorthwestern Michigan College · Traverse City, MIBuilt 1976 · S/N 27-7654191 N40510Yonika Richard J · Northbridge, MABuilt 1973 · S/N 27-7405241 N4051PEagle 64 LLC · Stuart, FLBuilt 1958 · S/N 23-1528 N40522Khag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 27-7405255 N40557Legacy Aviation LLC · Tea, SDBuilt 1973 · S/N 27-7405297 N40559Frost Aviation Services Inc · Las Cruces, NMBuilt 1973 · S/N 27-7405300 N40566Miller Stan · Skiatook, OKBuilt 1973 · S/N 27-7305188 N40569Harvey Sawyer N · Jaffrey, NHBuilt 1974 · S/N 27-7405310 N40571Bwh Leasing LLC · Lewes, DEBuilt 1974 · S/N 27-7405313 N40578Dna Flight Ops LLC · Edgewater, FLBuilt 1974 · S/N 27-7405322 N40581Chagres Aero LLC · Albuquerque, NMBuilt 1974 · S/N 27-7405325 N40588Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 27-7405332 N40592Rml Aircraft Inc · Staunton, VABuilt 1974 · S/N 27-7405337 N40599Tcb Aviation Inc · Knoxville, TNBuilt 1974 · S/N 27-7405345 N405TSRichard N Appling · Ellensburg, WABuilt 1963 · S/N 30-159 N4060LBentley Aviation Services LLC · Lewes, DEBuilt 1966 · S/N 27-3324 N4062PLgop LLC · Maple Grove, MNBuilt 1958 · S/N 23-1540 N4064PVali Air Service LLC · Livingston, MTBuilt 1959 · S/N 23-1542 N4067PAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1959 · S/N 23-1545 N4075PHolder Jeffrey J · Madison, GABuilt 1958 · S/N 23-1537 N4079PN4079p LLC · Peoria, AZS/N 23-1556 N407AFRuff Brent M · Santa Clarita, CABuilt 1966 · S/N 30-1285 N4085PTango Bravo Aviation LLC · Taylorsville, MSBuilt 1959 · S/N 23-1563 N4087PPankratz Laura M · Stroudsburg, PABuilt 1959 · S/N 23-1565 N4088PBas Part Sales LLC · Greeley, COS/N 23-1561 N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570 N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572 N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573 N4095PTorell Pamela O · Port Saint Lucie, FLBuilt 1959 · S/N 23-1574 N409KJBoard Of Trustees · Battle Creek, MIBuilt 2021 · S/N 4496523 N409LAAnderson Wilma (Lori) · Blue Mound, ILS/N 24-1494 N40DACirrus Design Corp · Duluth, MNBuilt 1965 · S/N 30-904 N40JSAir Flight Enterprises Inc · South Daytona, FLS/N 24-3269 N40LWMorgan Aviation LLC · Oak Harbor, WABuilt 1975 · S/N 27-7554146

Back to AD 85-02-05 R1