AD 2010-26-05 R1
Registered aircraft · 1,068
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:2010-26-05-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:2010-26-05-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:2010-26-05-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:2010-26-05-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.
N696RGPecos Bend Royalties Lllp · Midland, TXN699BGWord Of Life Christian Center Inc · Darrow, LAFirst renewal noticeN69ECAuto Midewst Inc · Niles, ILN69FHCarol 1 LLC · Nashville, TNN6FJFlying Farmer LLC · Wilmington, DEN700DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN700FLFl Aircraft LLC · North Little Rock, ARN700PGAviation Xx LLC · Wilmington, DEN700SWSafeway Leasing Inc · Westmont, ILN701PPaccar Inc · Seatac, WAN702AKMatapalo Holdings LLC · Hialeah, FLN702NWNext Wave Aviation LLC · Henderson, NVN703PPOvation Jet Parts LLC · Dover, DEN704JDClear Horizon Investments LLC · Overland Park, KSN705WLAspen Peak LLC · Houston, TXN706PPaccar Inc · Seatac, WAN707BEMoonraker Aviation LLC · Blacksburg, VAN707CXV1vr LLC · Wilmington, DEN707MTMt 7 Aircraft LLC · Dallas, TXN709DPWilmington Trust Co Trustee · Wilmington, DEN70BRRegistered aircraftN70FKChildress Klein Management Services LLC · Charlotte, NCN70LFWind Turbine And Energy Cables Corp · Hasbrouck Heights, NJN70LXLimerick Aviation LLC · Denver, CON70TFRex Realty Co · Saint Louis, MON70TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN710ETQuack Quack LLC · Portland, ORN710PPaccar Mexico Logistics Inc · Seatac, WAN711FJBirner Aviation LLC · Earth City, MON711RWAuto & Otolar LLC · Lawrence, KSN711TJCenturion Investments Inc DBA · Chesterfield, MON711TQGrey Falcon LLC · Ewing, NJN711WHKcm Ventures Whitefish 2 LLC · Arlington, TXN711WVRoss Airplane LLC · Parkersburg, WVN713AGAgee Richard E · Houston, TXN714JBOjw LLC · Wilmington, DEN715CBPilot 1958 LLC · Knoxville, TNN715JCFlying Farmer LLC · Wilmington, DEN716BHM Hixson Aviation LLC · Lake Dallas, TXN716GTS5 Aviation LLC · Longview, TXN717DHDarkhorse Aviation LLC · Georgetown, TXN717LAAdcnt Management Co LLC · Dallas, TXN717LFOnpoint Avionics LLC · Downey, CAFirst renewal noticeN717TFRegistered aircraftN71949Wilshire Rental Corp · Dallas, TXN719MCCdm Leasing LLC · Shelby Township, MIN719SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN71MSkyview LLC · Wilmington, DEN720MLNorthwestern Mutual Life Insurance Co · Milwaukee, WIN720WYIron Bar Enterprises LLC · Hampstead, NC
Back to AD 2010-26-05 R1