Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N733MPCrawford Alan R · Buchanan Dam, TXBuilt 1976 · S/N 17268399 N733MSNorthgate Aviation Inc · Chico, CABuilt 1976 · S/N 17268402 N733MTWashington Rodney · Mitchellville, MDFirst renewal noticeBuilt 1976 · S/N 17268403

Back to AD 79-10-03 R2