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.
N3338RMitchell And Son Aviation LLC · Greenwood, INN3339DSale Reported · Kalispell, MTSale reportedN3339FRegistered aircraftN-number assigned, not yet registeredN3339TBritt And Ashley Kieffer Farms · Weiner, ARN333ADRegistration Pending · Lynchburg, VARegistration pending, pending cancellationN333AFChickasha Wings Inc · Chickasha, OKN333AMLally Glen Joseph · Pleasanton, CAN333BGWendt Brian R · Naples, FLN333BTVaughan Garland Lynn · Canyon, TXN333CEFera Margaret L · Allentown, PAN333CJDrj Aviation LLC · Dover, DEN333CTJrm Wings LLC · Farmington, UTN333DGAlligood Allen K · Wasilla, AKN333ESRebus LLC · Andover, KSN333FFBass Thomas M Trustee · Kalispell, MTN333FUIntricate Bay Operating LLC · Iliamna, AKN333HADoran Jeff · Westerville, OHN333HHJohnson Craig A · Canton, TXN333JWPhillips John Patrick · Cumming, GAN333KNKris Noone Air LLC · Wilmington, DEN333KVScearce Richard D · Mount Vernon, IAN333KWD G R Air LLC · Braselton, GAN333LAWilson Matthew · Weatherford, OKN333LDKickin Tires Aviation LLC · Lake Wales, FLN333LHKoelbl Aviation LLC · Whitesboro, TXN333LSBrown Richard G · Blanchard, OKN333MWThird Oak Aviation LLC · Statham, GAN333NEEarle Norman R · Hastings, FLN333PLPilot Maker LLC · Hayward, CAN333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN333QAFirth Lynn C · Auburn, NHN333QBAdams Chad D · Dayton, ORN333RXJourneys Aviation Inc · Boulder, CON333SFFerretti James L III · Port Orange, FLN333SHVitez David D · Morgantown, WVN333SJDonald Robert Ferguson · Billings, MTN333SPBelote David Eldon Trustee · Elbert, CON333SSCumulus Aviation Services LLC · Port Orange, FLN333UDSpecialty Aero LLC · Seattle, WAN333UJUgly Johns Aircraft LLC · Afton, OKN333UMUniversity Of Michigan Flyers Inc · Ann Arbor, MIN333VBHumes Garrett D · Leesburg, FLN333VWHelderman Laban W · Newton, NCN333WGWilliams Samantha L · Kendallville, INN333YFEagle Aviation LLC · Delray Beach, FLN333YTRegistered aircraftN333ZVWalker Wilber D III · Beeville, TXN3340JSteiner William Mark · Newport Beach, CAN3340RFrieze Rex · Fair Play, MON3340SRegistration Pending · Wilmington, DERegistration pending
Back to AD 97-01-13