Registered aircraft · 40,395

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.

N172KAVenture North Aviation LLC · Cloquet, MNS/N 172RG0854 N172KDKad Aviation LLC · Athens, ALBuilt 1976 · S/N 17267467 N172KGSimons Laura · London, KYS/N 17270311 N172KJJa Flight Services LLC · Sugar Cove, ILS/N 17268124 N172KPBitzan Joseph D · Charlotte, NCBuilt 1968 · S/N 17257218 N172KWTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272254 N172KYAir Dogs LLC · Mount Washington, KYBuilt 1975 · S/N 17266093 N172LCIfly Aviation LLC · Conway, ARBuilt 1974 · S/N 17263219 N172LFSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1979 · S/N 17273380 N172LGPolk Brandon A · Valrico, FLBuilt 1974 · S/N 17264203 N172LJN W Aviators Inc · Troutdale, ORBuilt 1975 · S/N 17266242 N172LNFly Aviation Corp · Wilmington, DEBuilt 1981 · S/N 17274794 N172MC172 Mikecharlie LLC · Ocala, FLBuilt 1975 · S/N 17265980 N172MDDc Aerial Photos Inc · Fredericksburg, VABuilt 1974 · S/N 17263421 N172MEBlue Ridge Airworks LLC · Charlottesville, VABuilt 1974 · S/N 17263996 N172MFRhody Skyhawk Flying Club LLC · Middletown, DES/N 17258001 N172MHHoward Michael G · Slaughters, KYBuilt 1978 · S/N 17271660 N172MKRivera Glauco A · Isabela, PRBuilt 1976 · S/N 17266714 N172MLHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17261580 N172MRGorge Winds Aviation Inc · Fairview, ORBuilt 1976 · S/N 17267684 N172MSAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1974 · S/N 17263928 N172MXDmac Aircraft LLC · Savannah, GAS/N 17269939 N172NEast Tennessee Pilots Club · Knoxville, TNBuilt 1978 · S/N 17270403 N172NCChase James W · Port Orange, FLS/N 17260468 N172NFPreston Richard R Trustee · Albuquerque, NMS/N 17275911 N172NPDv Aviation Inc · Brainerd, MNBuilt 1978 · S/N 17270971 N172NSWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17257968 N172PESale Reported · Kenmore, WASale reportedBuilt 1979 · S/N 172RG0042 N172PFMillard Richard A · Waverly, TNBuilt 1969 · S/N 17258891 N172PGAviation Career Enrichment Inc · Atlanta, GABuilt 1975 · S/N 17265821 N172PKKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1979 · S/N 17273616 N172PRPark Rapids Aviation Inc · Park Rapids, MNBuilt 1974 · S/N 17264084 N172PTSpanaflight LLC · Puyallup, WAS/N 17270734 N172PZFirst Class Aviation LLC · Galena, OHBuilt 1979 · S/N 17273109 N172QWRiese Jennifer P · Auburn, ALBuilt 1969 · S/N 17257999 N172RFEvans Jack · Albuquerque, NMBuilt 1980 · S/N 17274093 N172RGMaxwell Don P II · Longview, TXBuilt 1979 · S/N 172RG0083 N172RJRidgik George H · Jamestown, COBuilt 1974 · S/N 17263314 N172RRFly Lugu LLC · Southwick, MABuilt 1973 · S/N 17261788 N172RWD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272209 N172SAHalbauer Peter · Hartford, WIBuilt 1969 · S/N 17258302 N172SBBirmingham Flight Center LLC · Birmingham, ALBuilt 1976 · S/N 17267683 N172SFTichy Joseph R · Napa, CABuilt 1984 · S/N 172RG1149 N172SGLehner Raymond A Jr · North Fort Myers, FLBuilt 1973 · S/N 17261734 N172SKCruz Orlando R · Houston, TXBuilt 1978 · S/N 17271308 N172SNBukowski Robert · Hot Springs, ARBuilt 1969 · S/N 17258428 N172SRDiaz Robert Dorantes · Coalinga, CAS/N 17267952 N172SSWingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17260696 N172SXPersonal Aviation Inc · Poway, CABuilt 1979 · S/N 17273641 N172SZPowell Terry · Sheridan, WYBuilt 1975 · S/N 17265508

Back to AD 79-10-03 R2