Skip to content

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

N5390FHeights Flight Management LLC · Monroeville, NJBuilt 1976 · S/N 32R-7680522 N5391YHeartland Aviation Inc · Alliance, NEBuilt 1963 · S/N 27-2467 N53LJJessen Larry S · Damascus, ORBuilt 2023 · S/N LIV-500 N54004Sobey Peter L · Aurora, OHBuilt 1974 · S/N 27-7405354 N54072Dewitt Gary D · Encinitas, CABuilt 1974 · S/N 27-7405382 N54075Pilot Pros Inc · Miami, FLBuilt 1974 · S/N 27-7405385 N54077Geo Mar Co Aviation Ltd · Clyde, OHBuilt 1974 · S/N 27-7405389 N54089Island Birds Inc · St Thomas, VIBuilt 1974 · S/N 27-7405390 N54092Harper-Smith Michael · Tarzana, CABuilt 1974 · S/N 27-7405405 N54097Piper Nia 1 LLC · Doylestown, PABuilt 1974 · S/N 27-7405408 N540PSteenrod Kenneth A · Parsons, KSS/N 31-65 N540WBAirmart Aircraft Holdings Inc · Oak Ridge, NCBuilt 2002 · S/N 3257269 N54109Gilmores Glorious Goods LLC · Lewes, DEBuilt 1974 · S/N 27-7405421 N5411FMack Robert A · Brighton, COBuilt 1976 · S/N 32R-7780003 N54155Aerospace Trust Management LLC Trustee · Wilmington, DES/N 27-7405452 N54195Decruz Peter John · Hattiesburg, MSBuilt 1974 · S/N 27-7405472 N54198Valiair Lc Trustee · Casper, WYS/N 27-7405474 N541BPEdge Aircraft LLC · Denver, COBuilt 1999 · S/N 3257087 N541VBCartier John · Cumberland, RIBuilt 2003 · S/N 3257334 N54221Emission-Air Inc · Lexington, NCBuilt 1974 · S/N 27-7554014 N54224Coosa Air LLC · Rome, GABuilt 1974 · S/N 27-7554017 N54225Jpr Capital LLC · San Juan, PRBuilt 1974 · S/N 27-7554018 N54236B & R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 27-7554030 N54238Backcreek Farms Inc · Rougemont, NCBuilt 1974 · S/N 27-7554032 N54240Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554034 N54245Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554039 N5424DCarpenter Michael H · Mooresville, NCS/N 20028 N54258Nesbeda Peter J · Marlborough, NHBuilt 1974 · S/N 27-7554046 N543133seaslal LLC · Lakeland, FLBuilt 1974 · S/N 31-7405439 N5431FSea Container Sales Inc · New Waverly, TXBuilt 1976 · S/N 32-7740004 N5431YThompson Sherrel L · Pembroke Pines, FLBuilt 1964 · S/N 27-2508 N5432FHornish Thomas L · Malinta, OHBuilt 1976 · S/N 32R-7780007 N5433FNh86 Bumblebee LLC · Henniker, NHBuilt 1976 · S/N 32R-7780008 N543CBTwin Aviation LLC · Coushatta, LAS/N 500B1317 N543JCBritshaw LLC · Lansdale, PABuilt 1977 · S/N 31-7752103 N543SBBielder Street Aviation LLC · North Charleston, SCBuilt 1979 · S/N 31-7912034 N54417Moore Alan J · Hays, KSBuilt 1973 · S/N 32-7440052 N54429Dickinson Robert Trustee · Edmond, OKBuilt 1973 · S/N 32-7440053 N5442FMcclary James Emmett Jr · Athens, ALBuilt 1976 · S/N 32R-7780010 N5447YAnderson Michael W · Wayzata, MNBuilt 1964 · S/N 27-2528 N544PBPortland Patrol Inc · Lake Oswego, ORBuilt 2001 · S/N 3257238 N5451FVirginia Aviators LLC · Sterling, VABuilt 1976 · S/N 32R-7780011 N5454YMatthews Grover · Fairborn, OHBuilt 1964 · S/N 27-2539 N54621Atlantic Resources Of Miami Inc · Deland, FLS/N 27-7554036 N5470YWeber Mark J · Dalton, MABuilt 1964 · S/N 27-2560 N54772Watts John J · Murchison, TXBuilt 1975 · S/N 27-7554080 N54775Hankins Shannon G · Tulsa, OKBuilt 1975 · S/N 27-7554082 N54796Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554097 N54809Mgc LLC · Brandon, FLBuilt 1975 · S/N 27-7554108 N54810Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554109

Back to AD 84-19-03 R1