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.
N271AFBurke Aircraft Service Co LLC · Portsmouth, OHN271CACivil Air Patrol · Maxwell Afb, ALN271DCForum Aviation LLC · Middletown, DEN271JLSouthwest Aviation Enterprises · Haslet, TXN271LDVan Well Trucking LLC · Dallas, ORN271SLVan Bortel Aircraft Inc · Arlington, TXN271SPIndiana Department Of Administration · Greenwood, INN27216Jjep Aviation LLC · Seattle, WAN2722FBowen Michael D DBA · Noblesville, INN2724REcho Flight LLC · Tucson, AZN2726XSuttman Robert · Dayton, OHN272ARWinging It Inc · Stephenson, MIN272FGRidgeline Assets LLC · Wilmington, DEN272HFHorizon Flight Center LLC · Chesapeake, VAN272LPAa-Aero Inc · Fairfield, NJN272MMTownair LLC · Sandy, UTN272SBBailey Aviation LLC · Chesapeake, VAN272SPBlue Ryan LLC · Billings, MTN27300Rankin Kevin J · Maryville, MON2731YGeorgia Forestry Commission · Macon, GAN273CPCivil Air Patrol · Maxwell Afb, ALN273METopel Holdings LLC · Scottsdale, AZN273TCStanford Doug · Oak Harbor, WAN2740K2740k LLC · Prospect, KYN2744WWilhelm LLC · Denver, COFirst renewal noticeN2745MNfh Aviation LLC · Pikeville, KYN2746CChen Mark · Plano, TXN2747RWilliams Dwight M · Paragould, ARN2748FWirth Gerald J Trustee · New Lenox, ILN274BBLcb Leasing · Manassas, VAFirst renewal noticeN274CPCivil Air Patrol · Maxwell Afb, ALN274DGBourne Michael Paul · Crystal Bay, NVN274MESabra Davis Corp · Wilmington, DEN274MMHanzawa George DBA · Wahiawa, HIN275AAAoa Kissimmee Inc · Kissimmee, FLN275PEPhoenix East Aviation LLC · Daytona Beach, FLN275PTTruss Travis D · Stephenville, TXN275TXQualitair LLC Trustee · MichelstadtN276GTChristiansen Aviation LLC · Wilmington, DEN276MEBoersma Rances LLC · Warden, WAN276SALiberty University · Lynchburg, VAN276TATextron Aviation Inc · Wichita, KSN2772Lewis University · Romeoville, ILN277GTSvetfur Aviation LLC · Camden, SCN277MTException LLC · Manning, SCN277TCTranslift Inc · Holly, MIN277USCooper Robert · Sugar Grove, ILN278CA278ca LLC · Union Gap, WAN278FGRidgeline Assets LLC · Wilmington, DEN278JHRaytheon Co · Tucson, AZ
Back to AD 2003-24-13