Skip to content

Registered aircraft · 1,642

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:74-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13') 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:74-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
  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:74-18-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
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.

N195PJSwif LLC · Atlantic, IABuilt 1978 · S/N 32-7840092 N1968TGilbert Zachary A · Jekyll Island, GABuilt 1968 · S/N 32-40376 N1981HRegistration Pending · Saint Louis, MORegistration pendingBuilt 1977 · S/N 32-7700013 N198GME B Marine LLC · Lantana, FLBuilt 1974 · S/N 32-7440126 N198TLulfs Mark E · Mancelona, MIS/N 32-7200029 N1999SVernon Margo L · Friendship, TNBuilt 1969 · S/N 32-1162 N199MWWoftam Inc Trustee · Wilmington, DEBuilt 1979 · S/N 327940219 N19HJLogan Lonnie L · Grand Island, NEBuilt 1973 · S/N 32-7300020 N200CARosenberg Frank D · Tempe, AZBuilt 1979 · S/N 327940205 N200CF200cf LLC · Decatur, ILS/N 32-7700005 N2032MKab Air LLC · Eden Prairie, MNBuilt 1978 · S/N 32-7840077 N203SJCorrado Christopher · Newton, NJS/N 32-40037 N204PCHestertown Aviation LLC · Monroe, GABuilt 1973 · S/N 32-7440036 N204SJStuart M Davis Inc · Rice, WABuilt 1972 · S/N 32-7240097 N20787Crawford Donald Mark · Frisco, TXBuilt 1978 · S/N 32-7840181 N207MAStreamline Aviation LLC · Battlefield, MOS/N 32-40923 N207VRB&C Properties LLC · Bristol, WIS/N 32-58 N2084MAmdent Air LLC · Wyomissing, PAS/N 32-7840038 N2091PStahler Corporation Ltd · Bexley, OHBuilt 1979 · S/N 32-7940041 N2103XBrandon Capital Group Inc · Leland, MIS/N 32-7940084 N21183Bkr LLC · Jacksonville, FLBuilt 1978 · S/N 32-7840184 N21418Woodard Christopher Shane · Forney, TXBuilt 1978 · S/N 32-7840185 N21449Curry Robert B · Delphos, OHBuilt 1978 · S/N 32-7840186 N2145NRaschio Ernesto G · Miami, FLBuilt 1979 · S/N 32-7940034 N2147KAgati Inc · Chicago, ILBuilt 1978 · S/N 32-7940020 N2147NN701bt LLC · Carmel, INBuilt 1979 · S/N 32-7940035 N2147PStevens Nicholas · Fort Collins, COBuilt 1979 · S/N 32-7940042 N2148PHorizon Aviation LLC · Buffalo, NYBuilt 1979 · S/N 32-7940043 N2155HHarlan Eric E · Columbus, MSBuilt 1978 · S/N 32-7940016 N2158FCampbell Barrett Hunter · San Antonio, TXBuilt 1978 · S/N 32-7940005 N2158MLariscey Larry · Graniteville, SCS/N 32-7840040 N215CTahome LLC · Saint Petersburg, FLS/N 32501 N215STNapoleon Christopher D · Allegany, NYBuilt 1967 · S/N 32-891 N2161XLake Riley Aviation Inc · Excelsior, MNBuilt 1979 · S/N 32-7940088 N2162XTaylor Express Investments Inc · Wilmington, DES/N 32-7940089 N21683Flying H Inc · Hoxie, KSBuilt 1978 · S/N 32-7840188 N2170VB A Aeronautics LLC · Norridge, ILBuilt 1979 · S/N 32-7940071 N2172GSecond Wind Aviation LLC · Chesapeake, VABuilt 1978 · S/N 32-7940003 N2174SBarakat Robert H · Rocklin, CABuilt 1979 · S/N 32-7940054 N217LFSnyder Aero LLC · Joshua, TXBuilt 1969 · S/N 32-1157 N2180FGentle Breezes LLC · Johnson City, TNBuilt 1978 · S/N 32-7940012 N2180ZM&M Aero LLC · Wilmington, DEBuilt 1979 · S/N 32-7940102 N21825Shepherd David K J · Bakersfield, CABuilt 1978 · S/N 32-7840189 N2183KMaven Aviation LLC · Dillon, MTBuilt 1978 · S/N 32-7940022 N2183ZCondor Enterprises Inc · Elkins Park, PABuilt 1979 · S/N 32-7940105 N2187UFearneyhough Jack M · Gilbertsville, KYBuilt 1979 · S/N 32-7940059 N2196NThompson Kurt C · Rochester, MNBuilt 1979 · S/N 32-7940037 N2200SPa32 Aviation LLC · Blue Bell, PABuilt 1979 · S/N 32-7940055 N2202UAsp Legacy Holdings Corp · SpringwaterBuilt 1979 · S/N 32-7940061 N2204ULi'L Dawg Aviation Inc · Florence, ALBuilt 1979 · S/N 32-7940065

Back to AD 74-18-13