AD 80-25-07 R1
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
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.
N64451Registration Pending · Goodman, MSRegistration pendingN64453Cofa Operations LLC · Dothan, ALN64454True Blue Flying LLC · Wilmington, DEN64455Sales Eric D · Keystone Heights, FLN64456Registered aircraftN6445TCarver James Kevin · Durango, CON6445UFerrin Lora J · Rio Rancho, NMN6445YRomero Bernard L · Santa Fe, NMN64464Vector Air LLC · Erie, CON64465N64465 LLC · Fort Lauderdale, FLN6446DN2893e LLC · Reno, NVN6446WRichter Aviation Inc · Maxwell, CAN64477Rico Aviation Services Inc · Miami, FLN6447964479 LLC · Cortland, OHN6447ACouch Andrew W · Newport Beach, CAN6447QP&M Enterprises LLC · North Charleston, SCN6447UOlathe Spray Ser Inc · Olathe, CON64485Registration Pending · La Harpe, ILRegistration pendingN6448ABrown Frederick A · Scottsbluff, NEN6448MTarrant County College · Fort Worth, TXN6448QMicheliche Robert B · Federalsburg, MDN64493Neron II LLC · Lewes, DEN6449JBentley Aviation Services · Lewes, DEN6449TPelayo Fernando · La Puente, CAN644CMMckenzie Bradley J · Houston, TXN644DDArfvidsson Emil · Mountain View, CAN644VCElder Daniel R · Kalispell, MTN64507Quigley Patrick M · Slidell, LAN64508Roseville Aviation LLC · Roxboro, NCN64509Wing Adney F III · Live Oak, FLN6450GN6450g Inc · Jacksonville, NCN6450KOstrowski-Swope Roxanne M · Ortonville, MIN6450YAttica Flyers Inc · Lafayette, INN64510Gonzalez Leopoldo · San Antonio, TXN6451AAnywhere Atp LLC · Mount Juliet, TNN6451QRoss Terry J · Cibolo, TXN6451UPatterson Scott K · Roswell, NMN64524Ace Aviation 64524 LLC · Pembroke Pines, FLN64527Aspire Aviation LLC · Farmingdale, NYN6452QBennett Bruce R · Lexington, KYN6452UEllis & Ellis Aviation LLC · Haslet, TXN64530Dazi Inc · Wilmington, DEN64532Wings Over Texas Holdins LLC · Denton, TXN64535Panair Flying Club Inc · Miami, FLN64537Peters Ronald J · Fountain Hills, AZN64538Crittenden Grace · San Luis Obispo, CAN6453NUgly Johns Aircraft LLC · Afton, OKN6453TVandermay Monty K · Santa Fe, NMN64541Corbett William C · Havelock, NCN64542American Patrols Inc · Midland, TX
Back to AD 80-25-07 R1