AD 2007-23-13
Registered aircraft · 597
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:2007-23-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-13')
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:2007-23-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-23-13') 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.
N734DBN779at LLC · Punta Gorda, FLN740RBSummit Capital Partners Aviation Services LLC · Houston, TXN749TTHarpe Air LLC · Horseshoe Bay, TXN74GRRobinson George A IV · Houston, TXN750FLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN750MLLincoln Industries Inc · Lincoln, NEN753GJWarhawk Aviation LLC · Baton Rouge, LAN753MBSteel Diamond LLC · Sheridan, WYN757TRRegistered aircraftN75DHBrent Staggs Medical Consulting LLC · Little Rock, ARN75TMMilazzo Holdings LLC · Wales, WIN75WPSalt River Project Agric Improvement & Power Dist · Phoenix, AZN760ASNorsan Investors LLC · Concord, CAN764JSAhw Aviation Inc · Anchorage, AKN767KCBig Orange Sky LLC · Green Bay, WIN768JSSfh Inc DBA · Fargo, NDN76TFFca LLC · Leawood, KSN772CSH & D Aviation LLC · Smithfield, NCN773RBPymp LLC · Nashville, TNN774SBAirmed International LLC · Birmingham, ALN776WRTwin Eagles Aviation Inc · Fort Mohave, AZN777WYGulf Atlantic Airways Inc · Gainesville, FLN778BValiair Lc Trustee · Casper, WYN779RKMcaire LLC · Newton, NCN77MAM Aire LLC · Wilmington, DEN780CBQuality Liquid Feeds Inc · Dodgeville, WIN7867THoldsworth David · Crystal City, TXN786MXMadix Inc · Terrell, TXN789JSArs Air LLC · Newport Beach, CAN793BCFour Lee LLC · Jeffersonville, INN797MMNext Generation Aviation LLC · Beloit, WIN798JSLtn Aviation LLC · Draper, UTN801CBBaugh Aviation Services LLC · Orem, UTN803SCStrom Law Firm LLC · Columbia, SCN804CVPlastic Ingenuity Inc · Cross Plains, WIN804RDLonestar Aviation LLC · Kalispell, MTN807BWTejama LLC · Amarillo, TXN807JCGwu LLC · Saint James, MON808ACInterwings Aircharter Corp · Lewes, DEN808CEOpen Air LLC · Glendale, AZN80AB80ab Group LLC · Wichita Falls, TXN80JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN810BEChrysler Aviation Inc · Van Nuys, CAN811SH1212012 LLC · Omaha, NEN811WEWarmont Company · Midland, TXN812SHCamp Logistics LLC · Scottsdale, AZN813RERichmond 135 LLC · Norwalk, CTN813SHN813sh LLC · Omaha, NEN814BRWinston Electric Inc · Lubbock, TXN814SHSilverhawk Aviation Inc · Lincoln, NE
Back to AD 2007-23-13