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.

N172CCWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17260031 N172CDHnh Enterprises Inc · Lander, WYBuilt 1964 · S/N 17252386 N172CESan Diego Community College District · San Diego, CAS/N 172RG0529 N172CGWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264991 N172CHCrosby Flying Services LLC · Fort Worth, TXBuilt 1971 · S/N 17260288 N172CJAlsworth Caleb J · Port Alsworth, AKBuilt 1968 · S/N 17257173 N172CLByrne Matthew A · West Allis, WIS/N 17267882 N172CPShevchenko Antonina · Henderson, NVFirst renewal noticeBuilt 1979 · S/N 17273471 N172CWGoddard William W · Apple Valley, CABuilt 1974 · S/N 17263325 N172DADuncan Aviation · Lincoln, NEBuilt 1981 · S/N 17275313 N172DBK&T Aviation LLC · Milton, PABuilt 1976 · S/N 17268440 N172DGGrass Daniel L Trustee · Penn Valley, CABuilt 1972 · S/N 17260743 N172DLKling Aviation Inc · Friendswood, TXBuilt 1975 · S/N 17266166 N172DMErquiaga Jeff H · Rushville, NEBuilt 1978 · S/N 17270835 N172DPSuperior Aviation Gateway LLC · Tampa, FLBuilt 1980 · S/N 172RG0465 N172DSJb Air Services LLC · Framingham, MABuilt 1975 · S/N 17265198 N172DVLima Tango Aviation LLC · Mount Dora, FLBuilt 1968 · S/N 17256625 N172EPlymouth Flying Club Inc · Plymouth, NHBuilt 1974 · S/N 17263335 N172EBMiller David A · Kodiak, AKBuilt 1973 · S/N 17261560 N172ECNilo Aviation LLC · Arley, ALBuilt 1976 · S/N 17266723 N172EPCp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17267932 N172EQSpeck Richard G · Wilmington, DEBuilt 1973 · S/N 17262251 N172ERReczynski Jakub Krzysztof · Deland, FLS/N 1351 N172ESAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258019 N172EWWoodrum Stephen D · Mesa, AZBuilt 1975 · S/N 17265167 N172FCWmrc Properties LLC · Fort Pierce, FLBuilt 1978 · S/N 17270224 N172FGFly 172n LLC · Peoria, AZBuilt 1976 · S/N 17267586 N172FMStern Jason C · Roscoe, ILBuilt 1969 · S/N 17258008 N172FPOceanic Air LLC · Key West, FLBuilt 1971 · S/N 172-59815 N172FTAirlink California LLC · Diamond Bar, CAS/N 17270486 N172FXFlexjet LLC · Cleveland, OHBuilt 1978 · S/N 17271381 N172GSuperhawk Inc · Casselton, NDBuilt 1979 · S/N 17271959 N172GBAig Aeronautics LLC · Guaynabo, PRS/N 17260336 N172GCDairy Air Inc · Wyoming, PABuilt 1968 · S/N 17257234 N172GKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 17276603 N172GMWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267127 N172GRN172gr LLC · Tamarac, FLBuilt 1973 · S/N 17261991 N172GTAileron Buzz LLC · Daytona Beach, FLBuilt 1971 · S/N 17259831 N172HDSchadt Andrew M · Edwardsville, ILBuilt 1976 · S/N 17267191 N172HFBuiqui Aerospace Corp · Kissimmee, FLS/N 17264634 N172HLStankiewicz Adam · Merrimack, NHBuilt 1970 · S/N 17259079 N172HRArlington Flyers Club · Mill Creek, WABuilt 1977 · S/N 17269272 N172HTAuto Outlet Of Irvington LLC · Irvington, NJS/N 17257091 N172JBWood Jonathan R · Sedgwick, MEBuilt 1973 · S/N 17262206 N172JDBlack Hound Aviation LLC · Austin, TXBuilt 1974 · S/N 17263844 N172JGGroendyke Jerry G · Fort Pierce, FLBuilt 1969 · S/N 17257987 N172JHHaugen Jim · Maiden Rock, WIBuilt 1962 · S/N 17248803 N172JJFort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1975 · S/N 17265488 N172JLSutton Aircraft Salvage LLC · Palmer, AKS/N 17257724 N172JMCardinal Wings Aviation LLC · Buckner, KYS/N 17262202

Back to AD 79-10-03 R2