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.
N2842QLaning Roland · Monument, CON2842SRegistration Pending · Mountain Home, ARRegistration pendingN2842UDeshaies Robert · Cumberland, RIN2842XWatkins Andrew A · Newark, TXFirst renewal noticeN2843AKnerr Joshua DBA · Tehachapi, CAN2843RDrandike Aviation LLC · Scottsdale, AZN2843SRegistration Pending · Tequesta, FLRegistration pendingN2843UFlite Five Inc · Kiowa, KSN2843YHarper Fred S · Springerville, AZN2844ASmith Jon K · Adairville, KYN2844FN2844f LLC 0421 · Valentine, NEN2844QReigle Aviation · Palmyra, PAN2844SJacks Grady M · Mena, ARN2844VN2844 LLC · Riverton, UTN2844YChildress Hugh W · Ozona, TXN2845LShenk Ronald W · Palmetto, GAN2845RCarlson Kevin J · Dunedin, FLN2846FA-Z Aviation LLC · Bay City, MIN2846QStafford Richard J · Bayport, NYN2846XJones John J · Fort Worth, TXN2847AKozacek Carter A · Duluth, MNN2847LGervase Russell · Farmington, NMN2847QDobbelaere Craig M · Oakwood, OHN2847RCashman Jeremiah P · Bozeman, MTN2847VClinton Flying Service Inc · Clinton, NCN2848ALitzen Guide Service Inc · Kenai, AKN2848KNeuwirth Gerald F Trustee · Lawton, OKN2848QFirst Eclipse Ltd · Richmond, VAN2848RBoccaccio Peter A · Burke, SDN2848XZafar Umar · Oklahoma City, OKN2849AMettler James T · Camas, WAN2849FPrice Marvin H · Roseburg, ORN2849KWarren Mark W · Arlington, WAN2849QSilver Ranch Airpark Inc · Jaffrey, NHN2849RKoehler Paul Jeffrey · Perkasie, PAN2849XMoore Garrie William · Georgetown, TXN2849YZimmerman Leonard R · Middlebury, INN284DMDreamworks Aviation LLC · Palm Beach Gardens, FLN284EXCaravan Ex LLC · Kalispell, MTN284RARekast Flying Services Inc · Englewood, FLN285Crawford Geoffrey E · Cottonwood, CAN2850ASnyder Jason D DBA · Oakland, MDN2850FGozansky Elliott K · Birmingham, ALN2850LBergmann Robert A · Lake Placid, FLN2850RNorcal Skydiving LLC · Cloverdale, CAN2850XStricker Michael L · Sherwood, ORN2851LMorristown Flying Service Inc · Talbott, TNN2851RRegistered aircraftN2851YColdwell Samuel L · White Pine, TNN2852FLane Jeffrey A Trustee · Elm Grove, WI
Back to AD 97-01-13