AD 75-09-13
Registered aircraft · 4,787
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-09-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:75-09-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:75-09-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:75-09-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.
N540NEAirswiss Inc · Wilmington, DEN5416UU S Department Of Agriculture · College Station, TXN5416YKer Holdings LLC · Henderson, NVN5417CExecutive Aircraft Management Services LLC · Pompano Beach, FLN5417YFeldner Mark A · Schererville, INN541CMAero Parts LLC · Roselle, ILN5420UJohnson Michele J · Buena Vista, CON5421JPeruzzi John DBA · Los Angeles, CAN5424AFudurich David E · Goleta, CAN5424UWsol Michael P DBA · Huntington Beach, CAN5425AValiair Ltd Co Trustee · Casper, WYN5426CVirginia Air Inc · Roanoke, VAN542CGulf States Financial Services · Lafayette, LAN542EBSvoboda Erik S · Mentor, OHN542EMRw Air LLC · Boerne, TXN542MNKeeler Aviation LLC · Plattsmouth, NEFirst renewal noticeN5430AAdams Hay Farms LLC · Cedar City, UTN5432JSouthampton Wing LLC · Southampton, NYN5432MWorthington Loren D · Caldwell, IDN5434ASteele Group Insurance Agency Inc · Eugene, ORN5436UNewsom William Joel III · Roswell, GAN5439CLopez Hugo E · Mcallen, TXFirst renewal noticeN543BCRoeloffs Arie · Wendell, IDN543DGrantham Ray · Sevierville, TNN543EMPacific Air Flight School LLC · Long Beach, CAN543MPayne Jon R · Danville, PAN543VWich Robert · Norfolk, VAN5443JKg&C Investment LLC · Saint Charles, ILN5444UBooze Gregory Trustee · Punta Gorda, FLN5446GCentral Virginia Aviation Inc · North Dinwiddie, VAN5447ASchmidt Aaron B · Auburn, ALN5448JInfinity Aviators LLC · Scottsdale, AZN5453JC L Flight Associates LLC · Bakersfield, CAN5454XKair Aviation · Parkland, FLN5456YWings As Eagles LLC · Wilmington, DEN5457AGoebel Joseph · Palos Verdes Est, CAN5464VLivingood Richard A · Tucson, AZN5467APiedmont Air Services LLC · Helena, MTN5469XTechaero 210 LLC · Healdsburg, CAN547CHoch Jeffrey · Seattle, WAN547EMWolcott John · Peoria, AZN5482CSantiago Robert S · Torrance, CAN5484JCaba Joseph · Covington, LAN548GAHyannis Air Service Inc · Hyannis, MAN5490AN5490a LLC · Rutherfordton, NCN5495VPhillips Ruffin P Jr · Lexington, NCN54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNN54CCScythe & Spade Co · Grand View, IDN54DFSkywave Associates LLC · Spirit Lake, IAN54JQRegistered aircraftN-number assigned (import), not yet registered
Back to AD 75-09-13