Registered aircraft · 25,369

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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  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:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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.

N75SDVimco N75sd LLC · El Paso, TXBuilt 1973 · S/N 17260829 N75SEJansen Adam Roger · Sunnyvale, CABuilt 2005 · S/N 495-2005 N75TCMorales Luis · Florence, ORBuilt 1977 · S/N 17268913 N75VRSlt Global Alliances LLC · Las Vegas, NVBuilt 1979 · S/N P21000429 N75WFSjs Holdings LLC · Los Angeles, CABuilt 1980 · S/N P21000617 N7600FGiles Forrest D · Springtown, TXS/N 245-70 N7600VRegistration Pending · Phillipsburg, KSRegistration pendingBuilt 1976 · S/N 177RG0886 N76015Aldea Aviation Partners LLC · Encino, CABuilt 1976 · S/N 17268091 N76016Cape Fear Aviation Maintenance LLC · Fayetteville, NCFirst renewal noticeBuilt 1976 · S/N 17268092 N76019Grimley Robert J · Palermo, NJS/N 17268093 N7601GWright Carl E · Conesville, OHS/N 17259301 N7602FPreston Aviation LLC · Mount Dora, FLBuilt 1970 · S/N 755-70 N7602GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259302 N76032Brown Jeffrey A · Wellington, ALBuilt 1976 · S/N 17268097 N7603FJacobs Robert A · Grass Valley, CABuilt 1970 · S/N 756-70 N7603GFelstead R Keith Trustee · Medina, NYBuilt 1970 · S/N 17259303 N7603XHanson Scott E · Auburn, CABuilt 1977 · S/N R18200112 N76044Williams Cecil R · Clarksville, TNBuilt 1976 · S/N 17268101 N76047Registration Pending · Muskogee, OKRegistration pendingBuilt 1976 · S/N 17268103 N7604FKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1979 · S/N 17273262 N76053Ape LLC · Birmingham, ALBuilt 1976 · S/N 17268106 N76056Bormuth Alan R · Morganton, NCBuilt 1976 · S/N 17268108 N7605FPromise Road Aviation Inc · Pendleton, INBuilt 1979 · S/N 17273263 N76076Elite Airplanes LLC · Fort Myers, FLS/N 17268114 N7607EPowerbelt LLC · Glendale, CABuilt 1978 · S/N 17272115 N7607FRolinski Alexander S · Deland, FLBuilt 1979 · S/N 17273265 N7607GOwens Wilbur · Rch Palos Vrd, CAS/N 17259307 N7607LMeyer Maria S · New Fairfield, CTBuilt 1978 · S/N A1520825 N7607WZero Seven Whiskey LLC · Dewey, OKBuilt 1977 · S/N R18200066 N7608FAj Mush LLC · Dearborn, MIBuilt 1979 · S/N 17273266 N76091Riverside Flight Academy Inc · Riverside, CAS/N 17268121 N7609FKomberec Eric R · Kalispell, MTBuilt 1979 · S/N 17273267 N7610AScrap Materials Inc · Huntington, ARS/N A1520738 N7610GFalconer Robert H · Yolo, CABuilt 1970 · S/N 17259310 N7610XShezifi Mathew · Livermore, CABuilt 1977 · S/N R18200113 N7611FGeneral Aviation Support Corp · Rosamond, CAS/N 17273269 N7611GStaunton Curtis J · Tulelake, CABuilt 1970 · S/N 17259311 N7612GSwartwood Thomas C · Everson, WABuilt 1970 · S/N 17259312 N7614SNatural Pleasure LLC · Fayetteville, NCBuilt 1976 · S/N 574-76 N7614VTucker Aviation LLC · Kalispell, MTBuilt 1976 · S/N 177RG0891 N7615GWashington Samuel C · Washington, DCS/N 17259315 N76172Rjd Flight LLC · North Canton, OHBuilt 1975 · S/N 17265906 N76177Brown Emily D · Niceville, FLBuilt 1975 · S/N 177RG0817 N7618SBraun Michael T · Oconomowoc, WIBuilt 1976 · S/N 923-76 N7619GMercer Aviators Inc · Princeton, WVBuilt 1970 · S/N 17259319 N761BEAnderson Kristian L · Albuquerque, NMBuilt 1981 · S/N P21000660 N761CWOne Charlie Whiskey LLC · Austin, TXBuilt 1980 · S/N 21064042 N761ESCronsell Kenneth L · Hampshire, ILBuilt 1980 · S/N A1520947 N761FGWilliams Glenn D · Columbus, GABuilt 1980 · S/N A1520949 N761GGChocks Away Aviaton LLC · Redmond, ORBuilt 1980 · S/N A1520951

Back to AD 80-25-07 R1