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.
N9288XKs&G Management Inc · Carlsbad, NMN928AZOceano Packing Company LLC · Pismo Beach, CAN928CPCivil Air Patrol · Maxwell Afb, ALN928CTSkydonkey Aviation LLC · Valdosta, GAN928FGMustang Sally Aviation LLC · Camden, SCN928HLJ & M Sales & Leasing LLC · Abingdon, ILN928LPMontana Freedom Riders LLC · Corvallis, MTN928MAAnson Air LLC · Sugar Land, TXFirst renewal noticeN928ZAFf22 LLC · Scottsdale, AZN92959Warar Manjit Singh · Shreveport, LAN92966Six J Aviation LLC · Palestine, TXN92970Elizabeth City State University · Elizabeth City, NCN92977Redse Erik S Trustee · San Francisco, CAN92983Dw Above The Rest LLC · Las Vegas, NVN92FSEastern Kentucky University · Richmond, KYN92HFHeritage Asset Leasing LLC · Ronkonkoma, NYN92LCEastern Kentucky University · Richmond, KYN92VBClear Skies LLC · Eugene, ORN92ZSky Galaxy 1 LLC · Lake Placid, NYN9303NWings Over Texas Holdings LLC · Denton, TXN9305NRancho Av Leasing LLC · Temecula, CAN9309CVan Bortel Aircraft Inc · Arlington, TXN930BMCoastal Aviation LLC · Nags Head, NCN930CMR F Cooper Enterprises LLC · Scottsdale, AZN930CPCivil Air Patrol · Maxwell Afb, ALN930CTStark Holdings LLC · Kalispell, MTN9311PJjjfgt Capital Holdings LLC · Truckee, CAN9318WAutoscribe Arrow LLC · Fort Lauderdale, FLN931SJTss Flying Club Inc · Bethesda, MDN931VMVermeer Great Plains Inc · Olathe, KSN9324FKrueger Michael L D O · Fresno, CAN932BVNby Productions · Bristow, VAN932FGTextron Aviation Inc · Wichita, KSN933CPCivil Air Patrol · Maxwell Afb, ALN933CSTextron Aviation Inc · Wichita, KSN933FMSouthwest Aviation Enterprises · Haslet, TXN933LAMindy Limited LLC · Muscatine, IAN9342FChurchill David J · Bear, DEN9342TChristiansen Aviation LLC · Wilmington, DEN9344FAtp Aircraft 2 LLC · Wilmington, DEN9347TLewis University · Romeoville, ILN9348FDirty Side Down Aviation LLC · Georgetown, TXN934AZN934az LLC · Miami, FLN934CPCivil Air Patrol · Maxwell Afb, ALN934EREmbry Riddle Aeronautical University · Daytona Beach, FLN934MT8th Dimension Enterprises LLC · Englewood, CON93517Pjc700 LLC · Las Vegas, NVN9351FCarr Sam H · Spring, TXN9355TR-Trans LLC · Bad Axe, MIN9357ZJlh Farms Inc · Dumas, AR
Back to AD 2003-24-13