Registered aircraft · 40,394

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.

N99243Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276418 N9924BNatre Air II LLC · Tipton, INBuilt 1982 · S/N 172RG1082 N9924DFoshee Todd · Brownfield, TXBuilt 1959 · S/N 18-6967 N9924QMy Way Aviation LLC · Weston, FLBuilt 1975 · S/N 17265868 N9924VEdwards Kevin M · Grass Valley, CAS/N 17264558 N9924WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23448 N99253Mitiguy Aviation LLC · Stow, MABuilt 1985 · S/N 17276421 N9925DZaczkowski Paul S · Tok, AKBuilt 1959 · S/N 18-6969 N9925QRoeder Cara R · Lake Charles, LABuilt 1975 · S/N 17265869 N9925VGoodin Joshua W · Jacksonville, FLBuilt 1974 · S/N 17264559 N9925WBigler Danny L · Owasso, OKBuilt 1967 · S/N 28-23449 N9925YDaniel Hull R · Wasilla, AKS/N 98 N99263Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276424 N99265St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276425 N9926YMorgan Kenneth K · Norridgewock, MEBuilt 1961 · S/N 7GCB-116 N99273United States Air Force · Dover Afb, DEBuilt 1985 · S/N 17276427 N9927QAndrus Shane · Pullman, WABuilt 1975 · S/N 17265871 N9927USpotts James J · Henderson, NVBuilt 1977 · S/N AA5A0327 N9928QDavis John · Jackson, WYBuilt 1975 · S/N 17265872 N9928RJablonski Kenneth · Ann Arbor, MIBuilt 1960 · S/N TD-395 N9928ULarson John B · Bloomington, MNBuilt 1977 · S/N AA5A0328 N99295Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276429 N9929PFloeck Lesa M · Tucumcari, NMBuilt 1976 · S/N 18-7709009 N9929WLalor David P · Montello, WIBuilt 1967 · S/N 28-23453 N992CDPineland Properties LLC · Volga, SDS/N 56299 N992EZLarge Jon D · Wasilla, AKBuilt 1953 · S/N 25905 N992KCAg Ranch Services LLC · Lewistown, MTBuilt 1999 · S/N 2924 N992KSTrolard Jerry N · Vale, ORS/N 001 N992PEGould Martin W · Alba, TXBuilt 1993 · S/N 1992 N992RMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLS/N 22-6863 N992SBRv Nine LLC · Florence, COS/N 91160 N992TFFriendswood Aviation LLC · Friendswood, TXBuilt 1974 · S/N 28-7405237 N9930UCoffield Grant E · Mars, PABuilt 1977 · S/N AA5A0330 N9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeBuilt 1982 · S/N 172RG1084 N9931EN9931e LLC · Phoenix, AZBuilt 1979 · S/N 17272291 N9931QDexter Aero Club Inc · Stetson, MEBuilt 1975 · S/N 17265875 N9931ULett John S · Elk Grove, CABuilt 1977 · S/N AA5A0331 N99329Tactical Integrated Training Soluctions LLC · San Antonio, TXBuilt 1985 · S/N 17276432 N99338Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276433 N9933UMullins Russell H · Lagrange, GAS/N AA5A0333 N9933WSantangelo Troy M · Akron, PABuilt 1967 · S/N 28-23477 N99341Jlinn Aviation Inc · Quinlan, TXBuilt 1985 · S/N 17276434 N99344Global Tours & Travel Services LLC · Davie, FLS/N 17276435 N99347Skywarrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276436 N9934DLetkeman John K · Seminole, TXBuilt 1959 · S/N 18-6987 N9934QDoupe Services LLC · Fort Myers, FLBuilt 1975 · S/N 17265878 N9935DDavis Nigel L · Helena, MTBuilt 1959 · S/N 18-6988 N9935VD & S Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17264562 N9936QHunt Richard M · Columbus, OHBuilt 1975 · S/N 17265880 N9936USale Reported · Wailuku, HISale reported, pending cancellationBuilt 1977 · S/N AA5A0336

Back to AD 79-10-03 R2