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.
N206JAFabick John D · Saint Louis, MON206KMHoskins Marc R · Kennett, MON206LWestern Air Pilots LLC · Mountain Home, ARN206LBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN206LEFort Worth And Western Air Express LLC · Southlake, TXN206LGHotel Kilo Aviation LLC · Anchorage, AKN206LLMoondog Motorsports LLC · Missoula, MTN206MBAircraft Trustee Services Inc Trustee · Dover, DEN206MDAuction Aviation Inc · Boulder City, NVN206MESouthwest Erosion Control · Mckinney, TXN206MFMission Aviation Fellowship · Nampa, IDN206MNMartin Nelson & Co Inc · Seattle, WAN206MTBlue Spruce LLC · Bigfork, MTN206MWZaludy Aviation LLC · Paynesville, MNN206MXFrogfeet LLC · BarcelonaN206MZKtbr Holdings LLC · Statesboro, GAN206PFPatriot Fuels Inc · Alexander, NDN206PJIllingworth Paul John · Georgetown, TXN206PMTunnel Aviation LLC · Tunnel Hill, GAN206PQHogue LLC · Paso Robles, CAN206RAAcord Transportation Inc · Chandler, OKN206RPFinley Aviation LLC · Fort Worth, TXN206RR206 Adventures LLC · San Juan, PRN206SBCounty Of Santa Barbara · Santa Barbara, CAN206SJUrbana Aviation LLC · Woodstock, OHN206TBAir Supply LLC · Tuscumbia, ALN206UESmith Peter I Trustee DBA · Ocala, FLN206VBN206vb LLC · Batavia, OHN206VSBos Ranch LLC · Reno, NVN206WEM&B Holdings LLC · Verdi, NVN206WKKaw Corp · Mcallen, TXN206WYAerotrust Services Corp Owner Trustee · Wilmington, DEN206YPIm Aviation LLC · Laredo, TXN206ZB16d LLC · Vashon, WAN20704Atpce LLC · Wilmington, DEN20707Atpce LLC · Wilmington, DEN20711Atpce LLC · Wilmington, DEN20727Atpce LLC · Wilmington, DEN20747Above And Beyond Aviation LLC · Austin, TXN20773Smtm Holdings Inc · Wilmington, DEN2077NLilylands Aviation LLC · Redvale, CON207ALU S Imaging Flight Ops LLC · Bartow, FLN207CACivil Air Patrol · Maxwell Afb, ALN207CDCheek Gary L · Chandler, AZN207PBBernstein Petra M · Salisbury, MDN207SADyer LLC · Dyer, TNN207SFTextron Aviation Inc · Wichita, KSN2080QHyperion Enterprises LLC · Warrenton, VAN20818N20818 LLC · Wilmington, DEN2081JWings Over Texas Holdings LLC · Denton, TX
Back to AD 2003-24-13