Skip to content

Registered aircraft · 40,473

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-04-03-R2') 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-04-03-R2') 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-04-03-R2')
    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-04-03-R2')
  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-04-03-R2')
  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-04-03-R2')
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.

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 N733JJJordan Scott A · East Falmouth, MABuilt 2001 · S/N 80331 N733JLFordem Richard P Trustee · Borrego Springs, CABuilt 1976 · S/N 17268329 N733JMThunderbird Aviation LLC · Littleton, COBuilt 1976 · S/N 17268330 N733JPMarc Aircraft Holding LLC · Soldotna, AKBuilt 1976 · S/N 17268332 N733JSSchool Of Missionary Aviation Technology · Ionia, MIBuilt 1976 · S/N 17268335 N733JTCl Habitat Management LLC · Salisbury, MDBuilt 1976 · S/N 17268336 N733JWSeven 4 Zulu LLC · San Diego, CABuilt 1976 · S/N 17268339 N733KBGalion Air Inc · Galion, OHBuilt 1976 · S/N 17268343 N733KEStettenbenz David A · Wasilla, AKS/N 17268346 N733KGNesher Aviation LLC · Jacksonville, FLS/N 17268348 N733KJGaffney John · Lauderhill, FLBuilt 1976 · S/N 17268350 N733KKBend Aircraft Mechanics LLC · Bend, ORBuilt 1976 · S/N 17268351 N733KSChaffin Grant M · Blythe, CABuilt 1976 · S/N 17268357 N733KTCardin Thomas W · Kearney, MOBuilt 1976 · S/N 17268358 N733KVSutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 17268360 N733LEChagres Flight Training LLC · Albuquerque, NMBuilt 1976 · S/N 17268368 N733LFPerfect Speed LLC · Burlington, MABuilt 1976 · S/N 17268369 N733LKSkyvue Aerial Photos LLC · Leipsic, OHBuilt 1976 · S/N 17268373 N733LLLavalley Asset Management Inc · Potsdam, NYBuilt 1976 · S/N 17268374 N733LMAlstrom Ragnar O · Alakanuk, AKBuilt 1976 · S/N 17268375 N733LNJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1976 · S/N 17268376 N733LPDg Aviation Services Inc · Merritt Island, FLBuilt 1976 · S/N 17268377 N733LQFarriss James W · North Lawrence, OHBuilt 1976 · S/N 17268378 N733LSResearch Flight Inc · Wayzata, MNBuilt 1976 · S/N 17268380 N733LYLong Island Aviators LLC · Seaford, NYBuilt 1976 · S/N 17268386 N733MCMann Aviation LLC · Wilmington, DEBuilt 1976 · S/N 17268389 N733MDPaul R Berg Pa · Vero Beach, FLBuilt 1976 · S/N 17268390 N733MGBend Aircraft Mechanics LLC · Bend, ORBuilt 1976 · S/N 17268393 N733MLJennings Jacqueline L · Rome, NYBuilt 1976 · S/N 17268397

Back to AD 80-04-03 R2