AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N750NDUnd Aerospace Foundation · Grand Forks, NDN750RECarpenter Richard S · Goshen, OHN750RMMorse Ray Trustee · Cottage Grove, ORN750TSN949md LLC · Blossom, TXN750UOhio University · Albany, OHN750WLMiller John J · Canastota, NYN750XAMiller Peter D · Vernon, VTN750XSSchmalzel Douglass A · Allenton, MIN750YTwo Bar Aviation Inc · Lincoln, NEN750ZLJohnson Chad T · Roseau, MNN751Pere Guy A · Cold Bay, AKN75105Mitchell Maverick LLC · Mitchell, SDN75108Haga Christian K · Thousand Oaks, CAN75109Knox Warrior Corporation · Mount Vernon, OHN7510EShier Aviation Corp DBA · San Diego, CAN7510FGrand Canyon Flyers LLC · Flagstaff, AZN7510HVan Wagner Aerial Media LLC · Hollywood, FLN7510JArmstrong Craig V · Casstown, OHN7510RNewton Hayden R · Charleston, MSN7510UCrop Doctor Aviation Inc · Hill City, KSN75110Triple R Aviation LLC · Cleburne, TXN75114Henrichs Debra L · Galloway, OHN7511ACouch Construction Co LLC · Palestine, TXN7511FEisenbrey Glen T · Greenbank, WAN75124Scott David A · Alliance, OHN75126Roth Darin · Max, NDN75127Amob 2 LLC · Baton Rouge, LAN7512CAirman Helicopter Inc · Fort Lauderdale, FLN7512FCulver Marc D · Anchorage, AKN7512JInfinity Aviation Group LLC · Nashua, NHN7512KLund James R · Champlin, MNN7512WNeblett Nathan · Fort Worth, TXN75132Ferngulf Investments LLC · Loretto, MNN75133Parmer Curtis S · Greensboro, NCN75134N75134 LLC · Honolulu, HIN75136Montgomery Carson B · Divide, CON75138High Island Seamless Inc · Gaylord, MNN7513FFrank Jerry W · Vonore, TNN7513JHenslin Maja Blu · Wyoming, MNN7513KRenfro Jacqueline L · Bethel, AKN7513RAnderson Agency Inc · Racine, OHN7513UWitt William A · Ennis, MTN75146Gaiser Richard Mark · Berrien Springs, MIN75147Hermes John P · Tarpon Springs, FLN75149Ryan Samuel P · Kodiak, AKN7514DAdams Stephen K · Lopez Island, WAN7514RN7514r LLC · Las Vegas, NVN7514WMagnum Leasing LLC · Waterford, MIN75151Olsen Aviation LLC · Atlantic, IAN75152Gibb John R · Ellensburg, WA
Back to AD 90-04-06 R1