AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N9287GCook Lynn H · Highland, UTN9287MRkm Leasing LLC · Greenwich, CTN92881Patton Aviation LLC · Billings, MTN92886Lewis John E · Clayton, NJN92887Butler Aircraft Company · Walla Walla, WAN92888Knudsen Wayne D · Dakota City, NEN92889Miller Andy · Marana, AZN9288CChase Michael D · Albuquerque, NMN9288GPupkar Stephen B · Brookeville, MDN92894Smith Rex H · Fort Bragg, CAN92895Dana Eric B · Davidson, NCN9289BWoodstock Aircraft Services Inc · White Lake, NYN9289GBolands North Inc · Binghamton, NYN9289XFull Send Aviation LLC · Fairview, TNN928ASA2g International LLC · San Juan Capo, CAN928CPCivil Air Patrol · Maxwell Afb, ALN928FGMustang Sally Aviation LLC · Camden, SCN928HPeterson Michael A · White Salmon, WAN928JCLatimer Nelson R · Oxnard, CAN928LPMontana Freedom Riders LLC · Corvallis, MTN928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeN928ZAFf22 LLC · Scottsdale, AZN92908C-140 Company LLC · Pensacola, FLN9290BFitts Roger W · Independence, ORN9290GPhillips Richard L · Vienna, OHN9290XPetrich John W · Metaline Falls, WAN9291Henderson Charles B · Houston, TXN92912Hill Charles W · Russellville, ARN9291AEvans James · Tuolumne, CAN9291BVan Meerveld Dwight E · Poplar Grove, ILN9291CMadland Patrick S · Anchorage, AKN9291HDawson William F Jr · Port Hueneme, CAN92922Perron Matthew B · West St Paul, MNN9292GDarter Lloyd R · Mountain Grove, MON9292HBlackhawk Flying Club Inc · Rockford, ILN92934Service Oriented Aviation Readiness (Soar) · Bolivar, MON92938Haney Christopher · Murrieta, CAN9293CHayes Dennis Paul · Des Moines, IAN9293XRod Ricky L · El Cajon, CAN92945Fla Inc · Wilmington, DEN9294BHall Justin E · York, NEN9294CBoulder Valley Aviation Inc · Boulder, CON9294HWet Dreams LLC · Erwinna, PAN9295BTow Dogs LLC · Kingman, AZN9295CLesmeister Dean J · Kindred, NDN9295HMiami Seaplane Tours Inc · Miami, FLN9295TViking Custom Builders Inc · Anchorage, AKN9296BColby Robert D · Bigfork, MTN9296CDinstel Delbert F · Park City, MTN9296GGreen Daniel C · Cedar Hill, TN
Back to AD 79-10-14 R1