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.
N1615FWells Edmund B · Austin, MNN1615VFrance Jeffrey A · Reedville, VAN16165Registered aircraftN16166Hayden Scott M · Walworth, WIN16169Trotter Patrick J · North Las Vegas, NVN1616CCleared Direct LLC · Seville, OHN1616FMarciel John L · John Day, ORN1616HMayworm Jeffrey A · Ocala, FLN1616QKrehbiel Bradley C · Lake City, MNN1616TDavila Alexander · Davie, FLN16174Cirrostrats Inc · Deland, FLN16177Norby Aviation LLC · Hopkinton, MAN16179Farrell Donald A · Owasso, OKN1617CRetroair Restoration LLC · Big Lake, AKN1617HFlying Cloud Cherokees Inc · Chanhassen, MNN1617QAljanabi Mohammed Khalid · Herndon, VAN1617VCook Timothy D · Ashville, NYN16180Last Mango Air LLC · Fond Du Lac, WIN16184Finkel David M · Shelbyville, INN16185Schwartz David W · Windsor, NYN1618FCastillo Giovanny G · Brodheadsville, PAN1618HMemrick Paul · Cedar Park, TXN1618MFluckey Gary T · Homer, AKN1618TRandolph James · Greensburg, PAN16194Booth Jesse R · Alamosa, CON16196Macdonald Kaitlyn A · Dillon, MTN16199Allbritton John Mark Trustee · Oakland, TNN1619FReeve Howard E · Minot, NDN1619QAmos Carl R · Chandler, INN161APT3 Aerosports LLC · Vian, OKFirst renewal noticeN161CTEddy Company Inc · Apple Valley, CAN161EWalsh David E · North Platte, NEN161GTYellow Jacket Flying Club Inc · Atlanta, GAN161KWKirtland Aero Club · Albuquerque, NMN161RMTurbine Screws LLC · Bozeman, MTN161VPConservation Aviation LLC · Washington, DCN16202Steward Charles M · Tuttle, OKN16206Schultz Aviation Services LLC · Crowley, LAN16207Martinez Jose Antonio · Orlando, FLN16210Simpson Dean H · Limon, CON16216Scott Jeffrey A · Camden, TNN1621FDimtroff John P · Issaquah, WAN1621HDavis Vance · Del Valle, TXN1621TBeats Driving Inc · Northbrook, ILN1622Susanville Aviation LLC · Susanville, CAN16221Aero Maintenance Inc · Vancouver, WAN16222Thumser Douglas Francis · Newcastle, CAN16223Flyhnz LLC · Oxford, NCN16225Tumminaro Michael · Neodesha, KSN1622CPutnal Aviation LLC · Ambrose, GA
Back to AD 97-01-13