Registered aircraft · 30

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

N101AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 36-008 N10FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 015 N10GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 010 N12FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 016 N135AJN135aj LLC · Englewood, COBuilt 1975 · S/N 036 N159RABar Aircraft Leasing LLC · Waterford, MIBuilt 1975 · S/N 024 N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037 N26FNDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 011 N31HKN31hk Inc · Miami, FLBuilt 1975 · S/N 016 N354LQBrunner Aerospace LLC · Georgetown, TXBuilt 1976 · S/N 055 N355CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 062 N35AJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 010 N361PJPremier Jets Inc · Hillsboro, ORBuilt 1974 · S/N 003 N362PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N 017 N364CLLacy Clay Trustee · Los Angeles, CABuilt 1981 · S/N 383 N382TCSkylink Jets Inc · Fort Lauderdale, FLS/N 039 N39FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 006 N435MSPuragain Water LLC · Escondido, CAS/N 054 N524PAPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 033 N547PAPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 012 N54PAVpc Planes LLC · Wilmington, DEBuilt 1974 · S/N 004 N635RJRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 35-017 N71PGPhoenix Air Group Inc · Cartersville, GABuilt 1975 · S/N 013 N80PGPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 063 N83FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 007 N84FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 002 N882SCAti Jet Inc · El Paso, TXBuilt 1984 · S/N 590 N905CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 005 N913CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 013 N91GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 032

Back to AD 83-08-03