AD 75-06-01
Registered aircraft · 2,832
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-06-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-06-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-06-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-06-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.
N383ASLee Holdings & Investments LLC · Marks, MSN383JPAtlanta Air Charter Inc · Kennesaw, GAN383RLRescue 383 LLC · Annapolis, MDN38537Optimumedicine LLC · Las Vegas, NVN385MQAcc Integrated Services Inc · Milwaukee, WIN386AFBank Of Utah Trustee · Portsmouth, NHN386ARRustic Corp · Fort Worth, TXN386GABarnes Inc · Lewiston, IDN387SCHeritage Aviation Management Ltd · Conroe, TXN388EERegistered aircraftN388TWTl Lobo Group LLC · Rockwall, TXN38JVKcsi Aerial Patrol Inc · Bakersfield, CAN38VDynamic Avlease Inc · Bridgewater, VAN38VSNv5 Geospatial Inc · Sheboygan Falls, WIN390PSMcm Holdings Inc · Lincoln, NEN391ACAmerican Champion Aircraft Corp · Rochester, WIN391HCFly-Area LLC · Charleston, SCN394LAAerial Solutions Of Tennessee LLC · Milan, TNN394SFCity Wings Inc · St Thomas, VIN395AAAdvanced Air LLC · Hawthorne, CAN395ABFr Air LLC · Palm Harbor, FLN395MBAdvanced Air LLC · Hawthorne, CAN396FWRoute 66 Aerostars LLC · Galena, KSN396MFRango Aviation LLC · Mesa, AZN397ALVertol Systems Co LLC · Wilmington, DEN398RKAir Worthy Inc · Lyon, MSN399CZN399cz LLC · Milwaukee, WIN399TWArx Air LLC · Windermere, FLN399WSGuardian Flight LLC · Lewisville, TXN39GKBusiness & Pleasure Air Charter LLC · Bakersfield, CAN39TNDenaina Leasing Agency LLC · Anchorage, AKN3BAConstruction Enterprises Inc · Franklin, TNN3GCTexas Air & Space Museum · Amarillo, TXN3MHN3mh LLC · Kalispell, MTN4005JPettis Aviation LLC · Atlantic, IAN4006YHendrickson Flying Service Inc · Rochelle, ILN400ACFly Pilatus LLC · Naples, FLN400GWGpw LLC · Laurel Springs, NCN400SCN400sc LLC · Walterboro, SCN401JTN401jt LLC · Denver, CON40269Freefall Express Inc · Gardiner, NYN402CSWoodley Aerial Leasing LLC · Walnut, ILN402DEDeby Ag Leasing Lp · Wakarusa, INN402GKGress Air LLC · Dunbar, NEN402JDefenbaugh Matthew J · Biggsville, ILN402LTBank Of Utah Trustee · Salt Lake City, UTN402REKingrey William S III · Richmond, TXN402SKOli Grow LLC · Baskin, LAN402SROli Grow LLC · Baskin, LAN402TSunflower Aero Inc · Atwood, KS
Back to AD 75-06-01