AD 80-25-06 R1
Registered aircraft · 210
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
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-06-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-06-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-06-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-06-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.
N116JJProgress Aviation LLC · Ellicott City, MDN1206NCapital Group Inc · Garden City, IDN124TMUniversal Aviation LLC · Decatur, ARN12RJDesert Air Ambulance Inc · Blythe, CAN12SNNechvatal Equipment Leasing LLC · Grand Blanc, MIN13HLFreedom 421b LLC · Jacksonville, FLN13PGJohnston Steven P · Coto De Caza, CAN1421MMcculloch Kurt D · Reno, NVN144MLLewis University · Romeoville, ILN146TJBirdboys2 Aviation LLC · Boerne, TXN1510GGmr Leasing LLC · Lincoln, DEN160DCPdii LLC · Concord, NCN188GWBrown Die Casting & Manufacturing Inc · Royse City, TXN18TN18t Ltd · Wilmington, DEN1QMAhlhorn Travis W · New Braunfels, TXN200BNRubber Duck Aviation LLC · Brunswick, GAN210GMStipe Leslie Wayne · Mcalester, OKN214CCSteele Aviation LLC · Tuscaloosa, ALN21SGTwo One Sierra Golf LLC · Seattle, WAN21SSMidwest Corporate Air Inc · Bellefontaine, OHN228JHBuzzed Landing LLC · Ocean Springs, MSN234MDMurphy David F · Amsterdam, NYN23RLCaljet Inc · Van Nuys, CAN241EWFort Carlos LLC · Fort Worth, TXN241TSGrey Matter Inc · Valley Springs, CAN260RAUpward Aviation LLC · Tulsa, OKN262MCAerospace Trust Management LLC Trustee · Wilmington, DEN264DCAirdvm LLC · Rcho Sta Marg, CAN2657NLoreto Aviation LLC · Wahoo, NEN26588Golden Aero LLC · Tarpon Springs, FLN2660UUnited Front Holdings LLC · Laguna Hills, CAN274MBAdams Aviation Services Inc Trustee · Wilmington, DEN284DMDreamworks Aviation LLC · Palm Beach Gardens, FLN287TASivad Holdings Corp · Nacogdoches, TXN28RHNational Airplane Sales & Leasing Corp · Lima, OHN28WDOptio Air LLC · Moore, OKN2957QGenerals International Inc · Red Oak, TXN299GBHoodoo LLC · Missoula, MTN311CASouthern Wings LLC · Shreveport, LAN311JHHuaco Aviation LLC · Waco, TXN315MDuckwing LLC · Reno, NVN31KSPaxton Jacob · Killeen, TXN321HASkytook LLC · Wilmington, DEN342RCHyland'S Pharmacy LLC · Wheeler, TXN344TCInternational Air Services Inc Trustee · Carson City, NVN355RTBeechwood Aviation LLC · Wilmington, DEN369RMRothschild Jonathan Trustee · Tucson, AZN375KCGuittard Chocolate Holdings Co · Burlingame, CAN37JKSsr LLC · Incline Village, NVN37RZOwens Martin · Telluride, CO
Back to AD 80-25-06 R1