AD 75-16-01
Registered aircraft · 17,795
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:75-16-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-01')
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:75-16-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-01') 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.
N12000Bear Creek Air LLC · Helena, MTN1204FMoroney Aviation LLC · Chugiak, AKN1206FHarrah Daniel R · Juneau, AKN12077Crawley Michael P · Penn Valley, CAN1208FYukon Air Service Inc · Fairbanks, AKN1209MShook Steve Trustee · Boulder, CON120GRStarlight Flight Aerial Tours LLC · Coppell, TXN120HPRegistration Pending · Lawton, OKRegistration pendingN120JHC&C Cessna LLC · Baltimore, MDN120WEHarbor Air Inc · Ann Arbor, MIN1211FGarner Greg A · Renton, WAN1213LBlack Jesse M Jr · Gainesville, GAN1216MHayward Flying Club · Hayward, CAN1217FUnited States Department Of Interior · Boise, IDN1219GRegistered aircraftN1219PJersey Christopher M · Willis, TXN121EESheldon Air Service LLC · Anchorage, AKN121EMRegistration Pending · Austin, TXRegistration pendingN121FHamilton Wayne J · Mesa, AZN121JMBullet Aviation LLC · Missoula, MTN121KSCa-C180j LLC · Addison, TXN121LLWild Blue Air LLC · Homer, AKN121MTc-Craft Aero Club Inc · Nampa, IDN121RAJohnson Owen M III · Seattle, WAN121RDVickery Forest H · Tallahassee, FLN1220CSky Bear Aviation LLC · Wilmington, DEN1220GGastrock Robert C Trustee · Anchorage, AKN1220MMcginty Flying Service LLC · Jones, LAN1220RKeywestaero LLC · Wilmington, DEN12222Thomas John S · Starkville, MSN1222FVelocity Sport LLC · Cedar Falls, IAN1224PM3 West Inc · Modesto, CAN1225QDupont Larry W · North Hero, VTN1227FPeterson Investments Inc · Polson, MTN1228MHillsboro Flying Club · Hillsboro, ORN122DTFine Point Aviation LLC · Carrollton, GAN122JAChase James P · Waco, TXN122JSGraham Design Services Inc · Dawsonville, GAN122TGAnzalone Donald Michael · Durango, CON122TTEveraert Filip L · Midland, MIN122VCTurner Terrance A · Anchorage, AKN122WTStoimenov Kirill H · San Andreas, CAN1231FRegistration Pending · Wasilla, AKRegistration pendingN1232FLloyd Land Plane I LLC · Brighton, CON1233BSutton Aircraft Salvage LLC · Palmer, AKN1233FFlyboyz LLC · Bourbon, MON1233MFrench Rollie T · Vermillion, SDN1233WDouble Crown Investments LLC · Earlsboro, OKN1234FSkydive New Hampshire LLC · Moab, UTFirst renewal noticeN1234YDe Jong Thomas · Buckeye, AZ
Back to AD 75-16-01