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.
N3168VAirgo Inc · Cetralia, ILN3168YSkydive Central New York LLC · Weedsport, NYN3169TOwen James D · Fort Lauderdale, FLN3169XVirgilio Domenico · Rochester Hills, MIN316ACheng Williams W · North Potomac, MDN316CAChoice Aviation LLC · Hamilton, MTN316EJPinpoint Logistics LLC · Cambridge, NEN316HYLakeview Aviation Inc · Newport, VTN316LSC M & N D Inc · Wilmington, DEN316MLJump N316ml LLC · East Berlin, PAN316PCRegistration Pending · Payson, AZRegistration pendingN316RALeading Edge Flight Services Inc · Hampshire, ILN316SFDoc Aviation LLC · Ponca City, OKN316WCEagle Aeronautics LLC · Chicago, ILN3170JDobrzynski Andrzej J · Chicago, ILN3170QRenfrow Denny · Kelseyville, CAN3170UHarrison Brian C · New London, OHN3170XFlying L Aircraft Inc · Fort Denaud, FLN3170YStillson John L · Rock Rapids, IAN3171CLand Sea & Air Inc · North Mankato, MNN3171DJohnson Donald B · Lino Lakes, MNN3171EJprg Aviation Inc · Orlando, FLN3171FRockin Rt LLC · Smithfield, UTN3171JRay Charles B · Prosser, WAN3171TVanlandingham Michael E · Oxnard, CAN3171XJohnson Christopher A · San Diego, CAN3171YDj Aviation LLC · Newburgh, INN3172EKruchten Larry A · Scottsdale, AZN3172FKuhn Joseph C · Manhattan Beach, CAN3172SSterling Flyers LLC · Lehi, UTN3172YPeters Barry S · Montague, CAN3173CMcgaha Justin L · Hooker, OKN3173ESkywarrior Flight Training LLC · Pensacola, FLN3173FJames Pearl LLC · Norfolk, VAN3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeN3173XRegistration Pending · Lutz, FLRegistration pendingN3174DRegistered aircraftN3174FRozier Harold H Jr · Blackshear, GAN3174QMclaughlin Daniel R · Xenia, OHN3174UMorris Debbie L · Columbus, GAN3174XRenner Colton A · Easley, SCN3175CClay Jason I · Imperial Beach, CAN3175FEstes Bernard R · Bumpass, VAN3175JJohnson David J Jr · Yucaipa, CAN3175UKeller Richard J · Martinsburg, WVN3175VDunaire LLC · Mechanicsburg, PAN3175YPittman Joel C · Apple Valley, CAN3176CYoung Thomas O · Battle Ground, WAN3176JAquaero LLC · San Antonio, TXN3176XHarless Phillip M · Mcdonough, GAFirst renewal notice
Back to AD 97-01-13