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.
N5004YElon Aviation LLC · Burlington, NCN500BWRaw Inc · Raleigh, NCN500GPEhg Flight LLC · Venice, CAN500TADouble 00 Investments LLC · Shaw, MSN50101Bas Part Sales LLC · Greeley, CON5011UAtp Aircraft 2 LLC · Wilmington, DEN5015HKnox Fred · Los Altos, CAN501ERVista Air Inc · Pacoima, CAN501GWSouthwest Aviation Enterprises · Haslet, TXN501PB34 North Holdings LLC · Ventura, CAN501SCSaz Dynamics LLC · Daly City, CAN501TMagic Carpet LLC · Hampton, NHN5020ABrown Jonathan Corey · Sherman Oaks, CAN5023JTexas State Technical College · Waco, TXN502ERZoeing Lease Inc · Lewes, DEN5030BInternational Air Services Inc Trustee · Carson City, NVN5033TJulol Investments LLC · Miami, FLN5035MFlight World Inc · San Juan, PRN5035XAtlantic Arrow Aircraft Inc · Kennesaw, GAN503CPCivil Air Patrol · Maxwell Afb, ALN503JSAlmont Orchards Inc · Chico, CAN503SPNew Horizon Aviation Inc · Warwick, RIN5043JValiair Lc Trustee · Casper, WYN504EAOlympic Jet Inc · Olympia, WAN504FAClow International Airport LLC · Bolingbrook, ILN504HLYellow Peril Aero LLC · Richmond, TXN50504Baker Merlin K · Bradford, OHN50545Christiansen Aviation LLC · Wilmington, DEN5054TWebb Larry R · Lima, OHN50588Registered aircraftN5059CLewis University · Romeoville, ILN505CPCivil Air Patrol · Maxwell Afb, ALN505HVHelivision LLC · Concord, NCN505LPWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN505PPOnionaire LLC · Aurora, ILN505RAFlying J Holdings LLC · Austin, TXN5061CMatheny Robert Gregg · Kingman, AZN5066HDohr William F · Williamsburg, VAN506EREmbry-Riddle Aeronautical University Inc · Prescott, AZN506PAState Of Connecticut · Hartford, CTN506SPHenrie Aviation LLC · Fairfield, NJN506TMTall Timber Flying Service LLC · Kalispell, MTN507DMChristiansen Aviation LLC · Wilmington, DEN507DROrtega Aviation Services LLC · Wichita, KSN507EREmbry-Riddle Aeronautical University Inc · Prescott, AZN507LAColumbia Leasing LLC · Hillsboro, ORN507PHocker Matthew Tutt · LondonN5082WAmeeti Robert Keith Trustee · Newport Beach, CAN50848Bearing Tree Land Surveying LLC · Oklahoma City, OKN50858Christiansen Aviation LLC · Wilmington, DE
Back to AD 2003-24-13