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.

N990VTWang Jinrao · Peachtree City, GABuilt 1969 · S/N 28-25910 N990XDl Industries Inc · Claremont, NHBuilt 1968 · S/N 28-5251 N99100Sterling Flight Training LLC · Jacksonville, FLBuilt 1985 · S/N 172-76401 N99104Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276403 N9910DMoe Gregor A · Sarasota, FLFirst renewal noticeBuilt 1959 · S/N 18-6951 N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854 N9910USky West Aviation Inc Trustee · Albuquerque, NMS/N AA5A0310 N9910YBaumgartner Larry C · Roseau, MNBuilt 1962 · S/N 7GCB126 N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855 N9911USandlapper Venutures Inc · Walhalla, SCBuilt 1977 · S/N AA5A0311 N9911WCategory One Aviation LLC · Atascadero, CABuilt 1967 · S/N 28-23433 N9911YTyrrell Luke L · Fairbanks, AKS/N 120 N9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648 N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856 N9913UThomason David F · Poplar Grove, ILBuilt 1977 · S/N AA5A0313 N9913WJcl Equipment Rental · Coleta, ILBuilt 1967 · S/N 28-23434 N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288 N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858 N9914SSheffield Robert A · Mooresville, NCBuilt 1967 · S/N 28-23672 N9914WYellow Bird Flying Club · Toledo, OHBuilt 1967 · S/N 28-23435 N9914YKnapper Jack A · Hibbing, MNBuilt 1961 · S/N 7GCB-112 N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412 N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078 N9915UBest Oren · Sunfield, MIBuilt 1977 · S/N AA5A0315 N9915WAlimardani Shahrakh · Aguanga, CABuilt 1967 · S/N 28-23436 N9916DUeeck Brett · Anchorage, AKBuilt 1959 · S/N 18-6958 N9916WCulp Mason J · Bonney Lake, WABuilt 1967 · S/N 28-23438 N99171Airlake Aero Inc · Lakeville, MNBuilt 1985 · S/N 17276414 N9917QStill Flying LLC · Gibsland, LABuilt 1975 · S/N 17265861 N9917WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23439 N9918DSnow Peter T Jr · Mcgrath, AKBuilt 1959 · S/N 18-6960 N9918EByrne Evan A · Mountain Lake Park, MDBuilt 1979 · S/N 17272289 N9918QCerqueira Luiz Fernando · Orem, UTBuilt 1975 · S/N 17265862 N9918USpencer Robert E · Independence, ORBuilt 1977 · S/N AA5A0318 N9919BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 172RG1080 N9919QBlomstrom Andrew R · Oregon, WIBuilt 1975 · S/N 17265863 N9919UFuller Michael D · Columbia, MDBuilt 1977 · S/N AA5A0319 N991ACXin Han Aviation LLC · Randolph, MABuilt 1979 · S/N 44-8095011 N991BJSilver Express Co · Miami, FLBuilt 1986 · S/N 28-16008 N991DCFigueroa Lionel Xavier · Sacramento, CAFirst renewal noticeBuilt 2004 · S/N 96-0363 N991KCSalt Lake Community College · Salt Lake City, UTBuilt 1999 · S/N 2898 N991KERaper Sandra K · Mesa, AZBuilt 2000 · S/N 3040 N991RRSale Reported · Inman, SCSale reported, canceledBuilt 2000 · S/N 5637 N992Baker Duke I · Jackson, MSBuilt 1957 · S/N 23-965 N9920BSchultz Robert G · Baker, FLBuilt 1982 · S/N 172RG1081 N9920LLarson Kris Kendrick · Fullerton, CAS/N AA5-0670 N9920UQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA5A0320 N9920VSkywarrior Flight Training Inc · Pensacola, FLBuilt 1974 · S/N 17264556 N9921UKing Dennis D · Venice, FLBuilt 1977 · S/N AA5A0321 N9921WPhoenix Composite Solutions LLC · Oscoda, MIS/N 28-23443

Back to AD 79-10-03 R2