Skip to content

Registered aircraft · 1,889

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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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:95-19-15-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.

N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038 N1540RPolar Tigers Inc · North Oaks, MNBuilt 1975 · S/N AA5B-0040 N1541RHall Daniel · Haskell, OKBuilt 1975 · S/N AA5B-0041 N1542RHoose Michael J · Cortland, NYS/N AA5B-0042 N1543RHettlinger Eric R · Terre Haute, INBuilt 1975 · S/N AA5B-0043 N1545RSanders Harrison S · West Columbia, TXBuilt 1975 · S/N AA5B-0045 N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048 N154GRRussell Gregory · Stevensville, MDBuilt 1976 · S/N AA5A-0213 N1555RDickenson William P · Lockport, NYBuilt 1975 · S/N AA5B-0055 N1558RTaylor Scott Douglas · Bethlehem, CTBuilt 1975 · S/N AA5B-0058 N1559RMoore Kira G · Newcastle, CABuilt 1975 · S/N AA5B-0059 N155BYYount Brian C · Fullerton, CAS/N AA5-0184 N155EFlieger LLC · Falls Church, VABuilt 1993 · S/N 10155 N1560RAbria Consulting LLC · New Milford, NJS/N AA5B-0060 N1561RKimmerer William J · Berkeley, CABuilt 1975 · S/N AA5B-0061 N1562RArnesen Thomas · Sioux Falls, SDBuilt 1975 · S/N AA5B-0062 N1568RRobinson Leonard C · Boca Raton, FLBuilt 1975 · S/N AA5B-0068 N1572RBurke Kenneth L · Colleyville, TXBuilt 1975 · S/N AA5B-0072 N1573RGrand Scott LLC · Okemos, MIBuilt 1975 · S/N AA5B-0073 N1575RSpurlock Daniel C · Harrogate, TNS/N AA5B-0075 N1579RSkelton James P Jr · Lithia Springs, GABuilt 1975 · S/N AA5B-0079 N1588RRed Earth Trips Inc · Wilmington, DEBuilt 1975 · S/N AA5B-0088 N158GCWebster Scott A · Plant City, FLBuilt 1976 · S/N AA5A-0158 N1592RWilliams Brian S · Marietta, GABuilt 1975 · S/N AA5B-0092 N1595RImpulsion Unlimited Inc · Huddleston, VABuilt 1975 · S/N AA5B-0095 N1596RTc Aviation Ltd · Fairbanks, AKBuilt 1975 · S/N AA5B-0096 N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098 N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974 N1600RColeman Daniel L · Chattanooga, TNBuilt 1974 · S/N AA5-0700 N160KTDiscover Resources LLC · Norman, OKBuilt 1976 · S/N AA5A-0115 N160TXStark Micah S · La Quinta, CABuilt 1976 · S/N AA5A-0143 N1611RFi Fi Flyers LLC · Littleton, MABuilt 1974 · S/N AA5-0711 N1613RGregg Jeffrey B · Sun Valley, CABuilt 1974 · S/N AA5-0713 N1613WArnold Stephen Paul · Falls Church, VABuilt 1972 · S/N AA5-0073 N1616RBerck Michael P · Clackamas, ORBuilt 1974 · S/N AA5-0716 N1673KRoznowski Wayne A · Alpena, MIS/N AA5B1193 N16CRHoughton Thomas J · Preston, CTBuilt 1974 · S/N AA5-0679 N16LCJohnson Neil D · Cincinnati, OHBuilt 1976 · S/N AA5B0385 N16MCHadachek Joshua L · Independence, ORBuilt 1977 · S/N AA5B0447 N16PXSmith Howard Michael · Wynne, ARBuilt 1979 · S/N AA5B1079 N176GRDdx Air LLC · Wyomissing, PABuilt 1976 · S/N AA5B-0348 N177GBHess Robert E · Rockford, ILBuilt 1975 · S/N AA5B-0123 N179GTNeedham Charles Scott · Washington, UTBuilt 1979 · S/N AA5B-0962 N17GTBarnes Albert A · Jupiter, FLBuilt 1975 · S/N AA5B-0011 N18APDrahzal Matthew R · Fernandina Beach, FLBuilt 1976 · S/N AA-5B-0291 N190AGCarson Ryan P · Albuquerque, NMBuilt 1990 · S/N 10000 N191DSBlackston Robert L · Belleville, ILS/N AA5B-0363 N191GCHughes Aviation LLC · Bedford, NHBuilt 1991 · S/N 10020 N1931TFordham Scott · Sag Harbor, NYBuilt 1975 · S/N AA50744 N1966LTiger N1966l Corp · New York, NYBuilt 1979 · S/N AA5B1220

Back to AD 95-19-15 R1