Skip to content

Registered aircraft · 25,369

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.

N733EBB&R Aircraft LLC · Wadsworth, OHBuilt 1976 · S/N 17268228 N733EJBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 17268235 N733ELNc 86 Flying Club Inc · Mooresville, NCBuilt 1976 · S/N 17268237 N733EMEricson William R · Traverse City, MIBuilt 1976 · S/N 17268238 N733ENBurr Ralph M · Roanoke, VABuilt 1976 · S/N 17268239 N733EPSkytec Aviation LLC · Boynton Beach, FLBuilt 1976 · S/N 17268240 N733ESWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17268243 N733ETCoco Aircraft Inc · Merritt Island, FLS/N 17273906 N733EVCriscolo John T · East Setauket, NYBuilt 1976 · S/N 17268246 N733EWS S T & J LLC · Minden, NEBuilt 1976 · S/N 17268247 N733EZBi Plane Adventures Inc · Kennesaw, GABuilt 1976 · S/N 17268250 N733FAJr Imaging Logistics Inc · Pasco, WABuilt 1976 · S/N 17268251 N733FCKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 17268253 N733FFRising Wings Aviation Inc · Casper, WYBuilt 1976 · S/N 17268256 N733FGPnw Aircraft Holdings LLC · Issaquah, WABuilt 1976 · S/N 17268257 N733FNJls Aviation LLC DBA · Fredericksburg, VABuilt 1976 · S/N 17268262 N733FPSorbi Aviation Inc · El Cajon, CABuilt 1976 · S/N 17268263 N733FRCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 17268265 N733FSArbach Enterprises Inc · Watertown, SDBuilt 1976 · S/N 17268266 N733FTRegistration Pending · Blaine, MNRegistration pendingBuilt 1976 · S/N 17268267 N733FUSimplifly LLC · Mesa, AZBuilt 1976 · S/N 17268268 N733FXCynthiana Flying Group Corp · Cynthiana, KYBuilt 1976 · S/N 17268271 N733GBDouble Bridges Aviation LLC · Enterprise, ALBuilt 1976 · S/N 17268275 N733GCWilliams Steve A · Tamms, ILBuilt 1976 · S/N 17268276 N733GKHearn Richard J · Gardner, KSBuilt 1976 · S/N 17268283 N733GLWhitewater Aviation Inc · Harrison, OHBuilt 1976 · S/N 17268284 N733GMHansen Jens E · Arroyo Grande, CABuilt 1976 · S/N 17268285 N733GQMarc Aircraft Holding LLC · Soldotna, AKBuilt 1976 · S/N 17268287 N733GSWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17268289 N733GTSanchez Demolition Inc · Bosque, NMBuilt 1976 · S/N 17268290 N733GVRiya Aviation LLC · Tracy, CABuilt 1976 · S/N 17268292 N733GXMarianas Air Transfer Inc · Saipan, MPBuilt 1976 · S/N 17268294 N733GZRichardson Charley Mack II · Mount Pleasant, SCBuilt 1976 · S/N 17268296 N733HAHuerta Holdings Inc · Santa Ana, CABuilt 1976 · S/N 17268297 N733HCWings Flight Enterprises Inc · Danville, KYBuilt 1976 · S/N 17268298 N733HDFuqua Michael B · Chatham, VABuilt 1976 · S/N 17268299 N733HFVr Aerospace LLC · Seattle, WABuilt 1976 · S/N 17268301 N733HHThomas Ramone · Philadelphia, PABuilt 1976 · S/N 17268303 N733HJRegistration Pending · Bay Harbor Islands, FLRegistration pendingBuilt 1976 · S/N 17268304 N733HKVan Anda Aviation LLC · Apopka, FLBuilt 1976 · S/N 17268305 N733HNAriaprima LLC · Port Orange, FLBuilt 1976 · S/N 17268308 N733HSSprague Daniel W · Roseburg, ORS/N 17268312 N733HTBrazos Valley Flight Services LLC · College Station, TXBuilt 1976 · S/N 17268313 N733HUStoughton Trailers Inc · Stoughton, WIBuilt 1976 · S/N 17268314 N733HZFranco Scott A · San Jose, CABuilt 1976 · S/N 17268319 N733JALakewood Investments LLC · Victorville, CABuilt 1976 · S/N 17268320 N733JCKrogh Michael L · Lees Summit, MOBuilt 1976 · S/N 17268322 N733JEHagerstown Flight School LLC · Hagerstown, MDBuilt 1976 · S/N 17268324 N733JFJones Atticus · Salt Lake City, UTBuilt 1976 · S/N 17268325 N733JHRiverside Flight Academy Inc · Riverside, CABuilt 1976 · S/N 17268326

Back to AD 80-25-07 R1