AD 97-01-13
Registered aircraft · 54,837
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-01-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:97-01-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:97-01-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:97-01-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.
N1595FVertical Horizon Aviation LLC · Sandown, NHN1595HSholy Fred · Granada Hills, CAN1595UJoiner Aviation LLC · Vinemont, ALN1596CFennell Kenneth J · Palmer, AKN1596ETeam 172-03 LLC · Warsaw, INN1596GN1596g Inc · Peachtree City, GAN1596MKret Geoffrey W · Godley, TXN1596TPlane Crazy Inc · Page, NDN1597HAerobox LLC · Seattle, WAN1597MDodson International Parts Inc · Rantoul, KSN1597YHelderman Laban W · Newton, NCN1598BTimerider Technologies Inc · Bishop, CAN1598HCarey Philip J Trustee · Wasilla, AKN1598MZigler James B · Big Lake, MNN1599MRegistered aircraftN1599QGonzalez Anthony H · Springfield, ORN159AEGalbari Geno · Wales, WIN159JMWyttenbach Joel N · Sauk City, WIN159RJBas Part Sales LLC · Greeley, CON159SKSeacrest Enterprises LLC · Asheville, NCN159TCShooting Star Museum · Devine, TXN15AFRogers Jeff · Harrogate, TNN15APIndy Air Sales LLC · Anderson, INN15AZHopkins Todd · Russellville, INN15BEAvalon Aviation USA Corp · Murfreesboro, TNN15BFMayes Richard A · Bend, ORN15BPTidmore Argie D · Pottsville, PAFirst renewal noticeN15CSBartlett Branden S · Chugiak, AKN15CUSalvato Kyle · Key Largo, FLN15CWN15cw LLC · Wilmington, DEN15FACivil Air Patrol · Maxwell Afb, ALN15FPFoxtrot Papa LLC · Slidell, LAN15FRScl Enterprises LLC · Waukesha, WIN15GWFlight Brothers LLC · Sachse, TXN15HJMorehouse Cooper · North Pole, AKN15JDSwanson Alec · Hanahan, SCN15NFRegistered aircraftN15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN15PAFlight Dynamics LLC · De Leon Springs, FLN15RAAviation Career Enrichment Inc · Atlanta, GAN15RSCalvert Gregory E · Essex, MDN15SRAllen Rodney · Connellsville, PAN15STSpray Brothers Aviation LLC · Great Bend, KSN15SVGore Joshua · Sedro Woolley, WAN15SWNi Oliver Xingyuan · Norfolk, VAN15TBEast West Helicopter Inc · Batesville, INN15TVDfl Management Corp · New Castle, DEN15TYArneson Kenneth W · Beaverton, ORN15VVLiberty Flying Club Inc Trustee · Wilmington, DEN15WGSwirk Rhonda L · Center Conway, NH
Back to AD 97-01-13