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.
N1471QRader Gregory · Baldwin City, KSN1471UEast Tenn Pilots Club Inc · Knoxville, TNN1472FCivil Air Patrol Inc · Maxwell Afb, ALN1472UEbben Robert A · New London, WIN1473FSilveira Paul J · Valdez, AKN1473M182p LLC · Oklahoma City, OKN1473SBattin Robert C · Cartersville, GAN1473YPetty James F · Crandall, GAN1474ESuffolk County Police Pilots Assoc · Bayport, NYN1474FJlb Aviation Services LLC · Woodbine, NJN1474UHentges Jerry J · Morris, MNN1475FAc Group LLC · Helena, MTN1475SMurdoch-Haig Alexandra · Kailua, HIN1475VGlobal Flight Training Solutions Inc · Immokalee, FLN1475YAbe Lincoln Flyers Inc · Lincoln, ILN1476QHarley Dennis E Sr · Cole Camp, MON1476SBk1 Farms LLC · Rock Port, MON1476UTampa Bay Aviation Inc · Clearwater, FLN1476YHamilton Gene A · Saegertown, PAN1477FMavity Reagan Chase · Clayton, GAN1477VSatermo Lee John · New Town, NDN1478FElliott Gabrial Adam · Hollywood, ALN1478MWestern Wind Aviation LLC · Suisun City, CAN1478YCunningham Richard E · Lafayette, CAN1479CBuilt Aviation LLC · Haymarket, VAN1479EAero Capital Lending LLC · Miami, FLN1479USperoni Pablo · Vieques, PRN147JFour Seven Jays Flying Club Inc · Rapids City, ILN147KLarson David W · New Iberia, LAN147MCSoloman Lynell J · Forks, WAN147MLPatton Andrew Joseph · Andrews, INN147NCorr Aviation Inc · Oxford, MSN147SHDe Camara Robert Michael · Boone, NCN147TXTexas Department Of Transportation · Austin, TXN147WFConsolidated Aero LLC · Gibsonville, NCN1480SAll In One Aviation LLC · Burleson, TXN1480USchaad Michael · Yorba Linda, CAN1481STraylor Margie · Cave Creek, AZN1481VTalbert Barbara E · Wesley Chapel, FLN1481YPoole Timothy W · Lyons, GAN1482VGriffin Samuel · Doniphan, MON1482YSamuelian Jenna A · Tehachapi, CAN1483MMaster Aviation LLC · Augusta, GAN1483QAttax LLC · Missoula, MTN1483UJohnson William Scott · New Market, TNN1483VRankin Kevin · Maryville, MON1484QIntegrated Structural Services Inc · Ringgold, GAN1484SRegistration Pending · Gualala, CARegistration pendingN1484UCrescent City Aviation Club LLC · New Orleans, LAN1484YHarrison Dennis N · New London, MO
Back to AD 97-01-13