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.
N3544GMid-Island Air Service Inc · Ronkonkoma, NYN3544WRapid Fleet I LLC · Carmel, INN3544ZSky Chiefs Aviation LLC · Gainesville, FLN3545JBarr Air Patrol LLC · Mesquite, TXN3546HOdonnell John Merritt · Kennebunkport, MEN3546QRahe John S · Marana, AZN3547FEastern Kentucky University · Richmond, KYN3547HCali Air LLC · San Ramon, CAN3547LSky Brothers LLC · Boulder, CON3547RL & R Flyers LLC · Bradenton, FLN3547TAircraft Guaranty Corp Trustee · Oklahoma City, OKN3548AKunard Kevin L · Pinedale, WYN3548MSpenser Air LLC · Starkville, MSN3548SSunny Skies Aviators LLC · Vernal, UTN3548VT-28 LLC · Salem, ORN35491L&W Leasing LLC · Smyrna, TNN3549HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN354CPCivil Air Patrol · Montgomery, ALN354CTCoast Flight Training And Management Inc · San Diego, CAN354ESN354es LLC · Stuart, FLN354STelfer William D · Perkasie, PAN354TAChristiansen Aviation LLC · Wilmington, DEN35502Sky Mates Inc · Wilmington, DEN3550TTotal Flight Aircraft Leasing LLC · Apex, NCN3552CAtlas Aviation Tampa Inc · Tampa, FLN3552DBarwick H Brooks III · Clinton, NCN3552L4wblue LLC · Waccabuc, NYN3552QRegistered aircraftN3553DM&R Aircraft LLC · Wilmington, DEN3554EZin Services LLC · Dove, DEN3554PCrimson Enterprises LLC · Wilmington, NCN3555LHillsboro Aero Academy LLC · Hillsboro, ORN3556VWestbank Fishing LLC · Kiln, MSN3556ZJohnson Paul A Trustee · Bloomfield Hills, MIN35578Christiansen Aviation LLC · Wilmington, DEN3557EWinged Bullies LLC · Spicewood, TXN35583Confluence Systems Consulting Inc · San Jose, CAN3559EGreater Flint Pilots Association Inc · Flushing, MIN3559RWest Indies Aviation Corp Trustee · Wilmington, DEN355CPCivil Air Patrol · Maxwell Afb, ALN355CWLevare Aviation Inc · Hillsborough, NJN355GMTextron Aviation Inc · Wichita, KSN355GWValiair Lc Trustee · Casper, WYN355MEBode Aviation Inc · Albuquerque, NMN355SRMoonglow Aviation LLC · Dover, DEN3560GVan Bortel Aircraft Inc · Arlington, TXN3560XCarey Brad Eugene · Grapeview, WAN3566ASun City Aviation LLC · Davie, FLN356BFRegistered aircraftN356CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2003-24-13