Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N519ACC & J Air Inc · Middletown, DEBuilt 2000 · S/N 1295-2000 N519FLeonard William E · Vancouver, WAS/N 1457-2010 N519MARed Baron LLC · Middletown, DEBuilt 2004 · S/N 489-2004 N519MKMcleod Martin · Carthage, NCBuilt 2010 · S/N 1099 2010 N51AMKerns Joshua S · Leander, TXBuilt 1978 · S/N 24-0430 N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602 N51CBPukach Greg V · Topeka, KSBuilt 1977 · S/N 297-77 N51CTLionudakis Chris L · Conroe, TXBuilt 1962 · S/N 2034 N51ERPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 484-2004 N51FRRegistered aircraftBuilt 1984 · S/N R18201988 N51GTBowen Austin T · Prairie Township, NDBuilt 1968 · S/N 103 N51MSDekervor Marc Phillippe II · La Mesa, CABuilt 1970 · S/N 17259085 N51WT51 Whiskey Tango LLC · Henrico, VABuilt 1969 · S/N 17258240 N520Registered aircraftBuilt 1977 · S/N 177RG1164 N5200HIowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17265373 N52012Skylens LLC · Hammond, LABuilt 1980 · S/N 17274393 N52013Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 17274394 N52015Gibbs Timothy L · Valley Grande, ALBuilt 1977 · S/N 177RG1141 N52017Worringer Richard G · Tower, MNBuilt 1977 · S/N 177RG1142 N52019Bryant Robert D · Perry, UTBuilt 1977 · S/N 177RG1143 N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305 N5201CCordero Jose Robert · El Paso, TXBuilt 1978 · S/N 24-0577 N5201DGriffin Thomas S · Spartanburg, SCBuilt 1978 · S/N 24-0578 N5201EGholizadehkasgari Mary Ambanoo · Jacksonville, FLBuilt 1978 · S/N 17271767 N5201HGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 17265374 N5201LMelchiorre Joseph G Jr · Milton, DEBuilt 1978 · S/N 24-0580 N5201NMarr Christopher M · Morrisville, NCBuilt 1978 · S/N 24-0581 N5201QAdams Clive P · Hendersonville, TNBuilt 1973 · S/N 17261770 N5201RWest Florida Flying Service LLC · Safety Harbor, FLBuilt 1974 · S/N 17263418 N5201UMccrary Enterprises LLC · Port Jefferson, OHBuilt 1978 · S/N 24-0582 N5201VMg Aircraft Inc · Fort Lauderdale, FLBuilt 1978 · S/N 24-0583 N5201XSims Raymond H · Navarre, FLBuilt 1978 · S/N 24-0584 N5201YShared Momentum LLC · Wilmington, DEBuilt 1978 · S/N 24-0585 N5202EMcdowell William R · Corpus Christi, TXBuilt 1978 · S/N 17271768 N5202JLizco Aviation LLC · Jackson, MOBuilt 1980 · S/N 17273729 N5202RHahn Douglas Keith · Waldport, ORBuilt 1974 · S/N 17263419 N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306 N5203DAcumen Aerotech LLC · Rogers, TXBuilt 1979 · S/N 17272446 N5203RGehman David W · Atmore, ALS/N 17263420 N52044Peck John E · Everett, WABuilt 1977 · S/N 177RG1150 N52046C10 Fire Aircraft Holding LLC · Sunriver, ORBuilt 1977 · S/N 177RG1152 N52048Time Flyers LLC · East Troy, WIBuilt 1980 · S/N 17274399 N5204SHildahl Gene G · Chelan, WABuilt 1980 · S/N R18201518 N5204VNimier Alexander M · Chatsworth, CABuilt 1980 · S/N 172RG0468 N52050Brown Thomas A · Lake Stevens, WABuilt 1977 · S/N 177RG1154 N5205DAlleghany Flying Club Inc · Hyndman, PABuilt 1979 · S/N 17272448 N5205RValley Pilots Flying Club Inc · Martinez, CABuilt 1974 · S/N 17263422 N52061Ortego Kenton M · Lake Charles, LABuilt 1977 · S/N 177RG1157 N52062Rpm Inc Flying Club · South Holland, ILBuilt 1980 · S/N 17274403 N5206MAeropaws Aviation LLC · Front Royal, VABuilt 1980 · S/N 15284504

Back to AD 80-25-07 R1