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.
N180HRRoberts Leon Thomas Trustee · Noxon, MTN180HSJones Van W II · Wilmington, OHN180HVVansoestbergen Harry J · Lincoln University, PAN180HXPompeo Nancy Lyn · Weymouth, MAN180JNorton L Thomas · North Fort Myers, FLN180JAAnderson A James · Shady Shores, TXN180JCBirds Boat Livery Inc · Raquette Lake, NYN180JDMerritt Jerome E · Oroville, CAN180JE8810 Capital Holdings LLC · Jupiter, FLN180JFAlexander Andrew B · Anchorage, AKN180JHKlein Flying Service · Lawrenceville, ILN180JJOflanagan Clancy H · Chowchilla, CAN180JKForbes James A · Monkton, MDN180JLHicks Carl Jr · Gig Harbor, WAN180JMN180jm LLC · Joplin, MON180JPMcmanamin John P · Anchorage, AKN180JSTakakjian Kyle · South Chatham, MAN180JTSproul Andrew W · Isabella, OKFirst renewal noticeN180JVBf Aviation LLC · Boulder, CON180JWStage One Associates LLC · Oxford, CTN180JZZehm John R · Breezy Point, MNN180KALofstedt Trever L · Scottsdale, AZN180KCThompson Robert M · Chandler, AZN180KEWerth Daniel · Anchorage, AKN180KKKrentsa Kenneth F · Stockbridge, MAN180KMLone Eagle Aviation LLC · Wilmington, DEN180KNDavis Brian L · Phoenix, AZN180KPPerhus Kelly E · Kindred, NDN180KSSky West Aviation Inc Trustee · Albuquerque, NMN180KWBadger Brothers LLC · Houston, TXN180LLietz Terry · Peshastin, WAN180LCLincoln David M · Renton, WAN180LEEverhart Leon J III · Gould City, MIN180LFKurtz Garold D · Mound City, MON180LGBrisson Gisele A · Hollister, CAN180LHHubbert Larry · Belding, MIN180LJGwinn Donald · Mccall, IDN180LLPoplar Grove Airmotive Inc · Poplar Grove, ILN180LMRegistration Pending · Anchor Point, AKRegistration pendingN180LTTugaw Leslie T · Omak, WAN180LWNorthstar Adventures LLC · Port Alsworth, AKN180MBBowers Michael J · Chugiak, AKN180MEKelly Jeffrey Allen Sr · Washoe Valley, NVN180MHRegistered aircraftN180MJHoke Michael J · Highlands Ranch, CON180MKCui Jin · Glendora, CAN180MMWeber Randy J DBA · Homer, AKN180MSVelociraptor Aviation LLC · Toney, ALN180MTJ & D Flying LLC · Edmonds, WAN180MWGiles Richard E · Vass, NC
Back to AD 97-01-13