AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-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:2003-24-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:2003-24-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:2003-24-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.
N6033SSuburban Air Corp · Castro Valley, CAN60349Mb Aviation LLC · Mount Pleasant, TXN6034BFxe Flightcenter Corp · Fort Lauderdale, FLN6034DDuro Vincent · Highland, CAN6034FToth Norman J · Spring Hill, FLN6034ZN6034z LLC · Missoula, MTN60356Gray Family Acquisitions LLC · Loomis, CAN6035ALandrys Aviation Services LLC · Pierre Part, LAN6035HExclusive Auto'S LLC · Preston, IDN60363Cumulus Aviation Services LLC · Port Orange, FLN6036AClive Consulting LLC · Dover, DEN6036YChristiansen Aviation LLC · Wilmington, DEN60372Above And Beyond Aviation LLC · Austin, TXN6038VEdb Air Inc · Wilsonville, ORN60395American Aviation Inc · Brooksville, FLN60397Vector USA LLC · Olive Branch, MSN60398Wagoner Aviation LLC · Clovis, CAN6039HMailing And Fulfilling America Inc · Fort Worth, TXFirst renewal noticeN603DCSeed Hub LLC · Glenarm, ILN603EREmbry-Riddle Aeronautical University Inc · Prescott, AZN603NDFm Aviation Services LLC · Arlington, VAN603TCReyes Gordon L · Houston, TXN6040CZach Air Corp · Byfield, MAN6040GPineland Holdings LLC · Gibsland, LAN6040STait Layne S · Bloomington, INN6042NCal Aggie Flying Farmers · Davis, CAN6042ZL&G Skycatcher LLC · Bradenton, FLN60430County Of Henrico Virginia · Henrico, VAN60435Georgia Forestry Commission · Macon, GAN60445Catskill Air LLC · Forestburgh, NYN60448Rlf N60448 LLC · Soap Lake, WAN6044JJj Ventures LLC · Billings, MTN6044ZMunger Stanley E · Sioux City, IAN60458Lindsarwatt Air LLC · Grand Junction, CON6045BPalmetto Flats LLC · Fort Pierce, FLN6045COrange County Sheriffs Department Rnsp · Santa Ana, CAN6045UPronghorn Aviation LLC · Lubbock, TXN6046GBeyond Potential LLC · Tucson, AZN6046RIds Inc · La Quinta, CAN6048THeartland Horseshoeing School Inc · Lamar, MON6048ZRegistration Pending · Wilmington, DERegistration pendingN6049KDeck Chair Air LLC · Bend, ORN6049SJ Birds LLC · Peyton, CON6049VBlackbird Alliance LLC · Rancho Mirage, CAN604AGSgflight5 LLC · Lake Zurich, ILN604CPCivil Air Patrol · Maxwell Afb, ALN604DCRomee Aviation LLC · Dallas, TXN604EREmbry Riddle Aeronautical University Inc · Prescott, AZN604NDHeavy Metal Air LLC · Farmingdale, NYN604TTUniversity Of Alaska Anchorage · Anchorage, AK
Back to AD 2003-24-13