AD 97-07-03
Registered aircraft · 605
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:97-07-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-07-03')
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:97-07-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-07-03') 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.
N138RA & K Aviation LLC · Wenatchee, WAN13ALNorthstar Holdings LLC · Anchorage, AKN13CAAeroclub Management LLC · Cincinnati, OHN13ESCsl Holdings LLC · Drayton, NDN140RDAlpha Whiskey 3 LLC · Brandon, MSN141MEFox Heather J · Bettles Field, AKN144ASValiair Lc Trustee · Casper, WYN146DCAztec Worldwide Airlines Inc · Wilmington, DEN146JMarc Inc · Bolton, MSN1470BBerger Leo · Nampa, IDN14APGlobal Air Concepts LLC · Anchorage, AKN151STWildman Lake Lodge Inc · Anchorage, AKN154WWAlpha Whiskey 1 LLC · Brandon, MSN158JDNavajo N158jd LLC · Wilmington, DEN159DSynapse USA LLC · Mesa, AZN165TTMakushin Logistics LLC · Fairbanks, AKN16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVN16YPSebastian Aero Services Inc · Guaynabo, PRN179RMRaven Air LLC · Coral Gables, FLN17PSNorris C · Land O Lakes, FLN1872EAmerican Valet Air Inc · Wilmington, DEN1872HDodson International Parts Inc · Rantoul, KSN189SASouthern Aircraft Consultancy Inc Trustee · Casper, WYN18HLBusinessliner Inc · Ft Lauderdale, FLN18RLAlpha Whiskey 3 LLC · Brandon, MSN191AMInternational Air Services Inc Trustee · Carson City, NVN192CSDodson International Parts Inc · Rantoul, KSN196AGMarc Inc · Bolton, MSN19CBCirrus Flying Professionals LLC · Hollywood, FLN1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKN200P10x Aviation Partners LLC · Stuart, FLN200PVPrestwick Chase Inc · Saratoga Springs, NYN200RARagan William W · North Kansas City, MON200SJChanney Aviation Group LLC · Las Vegas, NVN202DSValiair Lc Trustee · Casper, WYN207MDGv Air Inc · Medford, ORN20LXLockheed Martin Corporation · Palmdale, CAN212RAAbin Ricardo · Miami Lakes, FLN213ACRtb Transport LLC · Evans, GAN21406Makushin Logistics LLC · Fairbanks, AKN21ABAriel J Quintela LLC · Odessa, FLN21HGDrisco LLC · Ponca City, OKN21HLChieftain Aviation Inc · Marietta, GAN221ACAusten Air LLC · Lees Summit, MON225TMSouth Of Snow Adventures LLC · Hartwell, GAN227AKHanzawa George K · Wahiawa, HIN227ECEcjet Inc · Downey, CAN227RMHeli Coral Inc · Wilmington, DEN230ASN230as LLC · Wilmington, DEN234CEAir Arctic Inc · Fairbanks, AK
Back to AD 97-07-03