AD 76-19-07
Registered aircraft · 1,812
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:76-19-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-19-07')
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:76-19-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-19-07') 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.
N221DFMoeckel Herbert R · Tunas, MON2222ZParsons John C · Wichita, KSN222HLDouble K Flying LLC · Scottsboro, ALN224KJam Three LLC · St George, UTN226MAdams Larry Gene · Parker, AZN228FPRegistered aircraftN229TYSchilling Aviation LLC · Britton, MIN22TKGreen Theodore G · Franklin, WIN232YPGill Joshua Daniel · Tucson, AZN23LGGist Thomas Hottel III · Little Rock, ARN250CCAerodynamics Worldwide Inc · Wilmington, DEN250GTComanche Golf Tango LLC · Clifton, VAN250LJCarew Aviation Inc · Appleton, WIN250PCHerndon Timothy M · Kingston, OKN250RBWestern Slope Aviators LLC · Delta, CON250TJTalley John T · Clifton, TXN25MHumble Ventures Inc · Tempe, AZN260BCFlying J LLC · Bulverde, TXN260CDMarlow Bruce D - Trustee · Nevada City, CAN260DTInternational Air Services Inc Trustee · Carson City, NVN260GCFeline Health Inc · Hampstead, NCN260JFKropp Christian Trustee · Azle, TXN260NCYounhorsh Sales LLC · Wilmington, DEN260PCRegistered aircraftN260SCN260sc Partnership Group LLC · Ogden, UTN266WLowell James · Tucson, AZN26CXCiholas Philippe A · Sedgwick, KSN277DDWicked Flyby LLC · Lewes, DEN27BRLarson Allen L · Capron, ILN27PCRegistration Pending · Houston, TXRegistration pending, pending cancellationN288ABSyrasoft Aviation LLC · Baldwinsville, NYN2904PRandall Airlines LLC · Wendell, NCN2947Moran M Michael · Chico, CAN29BJMax Total Time LLC · Lufkin, TXN29SCBrown Sherrie C · Cushing, OKN2ABBailey Richard T · Oregon City, ORN2DVLewis Paul A · Spring, TXN2RTBarnett Keri Trustee · Brownfield, TXN3030WZadnik Gary R · Vacaville, CAN309WPMcmahon Peter · Brookfield, CTN313MWClover George S · Catheys Valley, CAN31WHDerbecker David G · Katy, TXN320JLInspired Oasis LLC · Salem, ORN3228PPopejoy Marc · Fort Scott, KSN322JK & M Aviation LLC · West Liberty, KYN330JGCultra LLC · Naples, FLN333CBSecondary Minimums Task Force LLC · Kalispell, MTN333CXFlying Bs LLC · Canby, ORN33DNRegistered aircraftN33PHPine Creek Adventures Inc · Benton, PA
Back to AD 76-19-07