Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N536SBKilo One LLC · Saint Petersburg, FLBuilt 1996 · S/N 4636048 N5381TBlaes Christopher T · Gallatin, TNBuilt 1972 · S/N 32-7240106 N5382FRose James A · Boston, MABuilt 1976 · S/N 32R-7680520 N5382NHarrell Thomas · Ocala, FLBuilt 1982 · S/N 32-8224012 N538SBBurroughs Scott · Raleigh, NCBuilt 2000 · S/N 3257174 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

Back to AD 91-21-01 R1