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.
N2885YMiner Bradford Aviation LLC · Spanish Fork, UTN2886FWeldon Larry W · Titusville, PAN2886QWright Flyers Club Inc · Huber Heights, OHN2886UVon Linsowe David J · Vero Beach, FLN2887EMeeker Stanton · Squaw Valley, CAN2887LMello Stephen F · Ludlow, MAN2887RNaylor Michael Scott · Modesto, CAN2887SRobinson Andrew K · Pahrump, NVN2887XTolmachev Nikolay A · Anchorage, AKN2888ESterett Terry Alan Jr · New Port Richey, FLN2888FLynch Neil E · Ceresco, MIN2888KBooth William R Jr · Sterling, AKN2888QChilds William C · Bridgeport, ALN2888UBodo Martin Trustee · Los Altos Hills, CAN2889EWesellhigh LLC · West End, NCN2889FLander Kirt E · Kingman, AZN2889LSouthern Star Aviation LLC · Missoula, MTN2889RAircraft Structural Repair Inc · Hamilton, MTN2889SKinter Christopher A · Kodiak, AKN2889XKogele Donald J · Broadus, MTN2889YJust Jump Skydiving LLC · Laurens, NYN288AMAdams Aviation Services Inc Trustee · Wilmington, DEN288LSVacendak William A · Wasilla, AKN288LTGlatczak Jerome · Schofield, WIN288PCWright Air Service Inc · Fairbanks, AKN288RWNortheastern Assets Holdings LLC · Dover, NHN288TMSlaba Mark E · Arcadia, FLN2890FAeolus Aviation LLC · Franklin, TNN2890QCarrick Christopher A · Castro Valley, CAN2890SKeyte Clinton W · Colfax, CAN2890URedley Andrew Scott · Maryville, TNN2890VTampa Bay Soaring Society Inc · Zephyrhills, FLN2890YWomble Warren G · Chapel Hill, NCN28913Bellas Business LLC · Kalispell, MTN2891ARegistered aircraftN2891FBayshore Properties LLC · Hagerstown, MDN2891VSchaller Lee · New Athens, ILFirst renewal noticeN2892EJaars Inc · Waxhaw, NCN2892FSpeedtape Airways LLC · Williamson, GAN2892LSellers Michael E · Clam Gulch, AKN2892RBuenafe Constance Ann · Santa Fe, NMN2893EN2893e LLC · Reno, NVN2893UMerrell Jon P · Wolcott, NYN2893XOlson Philip D · Garden Plain, KSN2894LJohnson Nancy B · Vestavia Hills, ALN2894QFerkin Mark A · Caldwell, IDN2894VCuthbertson Steven M · Van Alstyne, TXN2895AAirspace Aerial Media LLC · Saint Louis, MON2895FWilson Paul D · Peachtree Corners, GAN2895QAmerican Patrols Inc · Midland, TX
Back to AD 97-01-13