AD 2002-23-11
Registered aircraft · 1,985
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:2002-23-11')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-11')
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:2002-23-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-11') 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.
N1459General Atomics Aeronautical Systems Inc · San Diego, CAN146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXN148AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN148SKBering Air Inc · Nome, AKN149CCCianbro Corp · Baltimore, MDN149SFAlpine Aviation Inc · Provo, UTN14HHDelaware Professional Aviation LLC · Dalton, GAN14NGFirst Avenue Management LLC · Savannah, GAN150CNKing Air Investments LLC · Ferriday, LAN150GXWest Penn Aviation LLC · Midland, TXN150KJAlpine Aviation Inc · Provo, UTN150RFR & F Wings III LLC · Liverpool, NYN150RLTigress Air III LLC · California, MDN150YDSfh Inc DBA · Fargo, NDN151ELCarolina Turbine Sales Inc · Raleigh, NCN151QDepartment Of Homeland Security · Washington, DCN151WTKo Aviation LLC · Wilmington, DEN152WLHeart One LLC · Little Rock, ARN153GAAlpine Aviation Inc · Provo, UTN153GLAlpine Aviation Inc · Provo, UTN154GAAlpine Aviation Inc · Provo, UTN154GLAlpine Aviation Inc · Provo, UTN154KFRegistered aircraftN155AVTeton Leasing LLC · Pocatello, IDN155BBRegistration Pending · Greer, SCRegistration pendingN155CJUe-55 LLC · Helena, MTN1560Davis Aviation Inc · Brandon, MSN1568GUas Transervices Inc · Boca Raton, FLN156LAFresno Beverage Co Inc DBA · Fresno, CAN156TMWilmington Trust Co Trustee · Wilmington, DEN157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN159SFSuburban Air Freight Inc · Omaha, NEN15GABering Air Inc · Nome, AKN15KALighthouse Air LLC · Hobe Sound, FLN15WCDakota Aviation LLC · Santa Ana, CAN160RWRitch Air LLC · Visalia, CAN160SFTriumph Aviation LLC · Gaylord, MIN160SMAviation Star S LLC · Beaumont, TXN161VDepartment Of Homeland Security · Washington, DCN162GDepartment Of Homeland Security · Washington, DCN162GCUnited States Department Of Interior · Boise, IDN162QMartin Foundry Service Inc · Glencoe, ALN163BALbk Air LLC · Newark, DEN1655MMichigan Aeronautics Commission · Lansing, MIN165TGAmj Aviation LLC · Oneida, TNN165YVAlpine Aviation Inc · Provo, UTN166BASmith Joshua B · Kenai, AKN166CLKa Partners LLC · Thomson, GAN166SAClear Skies Ltd · Cincinnati, OHN167CDepartment Of Homeland Security · Washington, DC
Back to AD 2002-23-11