AD 75-20-06
Registered aircraft · 634
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-20-06')
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-20-06')
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-20-06') 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-20-06') 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.
N14751Maiorka Kevin D · Lockhart, TXN14754Registration Pending · Clarkston, MIRegistration pendingN14758Jim Franklin Aviation Service Inc · Ruidoso, NMN1476251 Adventures LLC · East Montpelier, VTN14764Bl14764 LLC · Homer, LAN14771Shiner Aviation LLC · Georgetown, TXN14772Koehn Loren M · Galva, KSN14782Roberts James B · Piedmont, OKN14783Braddock Zachary J · Ladson, SCN14786Registered aircraftN14792Ripley James Jefferson III · Frederick, OKN14793Clinton M Ward Pc · Vinita, OKN14798Ingle Stephen D · Bainbridge, OHN147PHSale Reported · Dallas, TXSale reported, canceledN147TBSullivan David L · Santa Fe, TXN14908Reiter Scott D · Leesburg, VAN14909Johnson Bruce M · Schertz, TXN14SFArnold Kiefer · East Prairie, MON15DQPrivette Hugh T Trustee · Colorado Springs, CON16AWFreas Joseph R · Simi Valley, CAN1730ATapley Brian K · Dothan, ALN179TWBlue Sky Aviation Investments LLC · Coconut Creek, FLN183SVQuality Feed Grains Inc · Harrison, ARN192CRIvas Edward P · Great Barrington, MAN1971VThompson Timothy · Prosser, WAN1979BLink John E · Hereford, TXN198VSkrow Works Inc · West Monroe, LAN1JJChrapczynski Daniel T · Sheffield Village, OHN200DSRathi Blythe P · Hayward, CAN200EBBretherton Carlos F · San Luis PotosiN2020Y707 Solutions LLC · Kalispell, MTN222SNNorris Jason M · Smyrna, TNN2232ZAlaverdi Omeed · California, MDN228CMKittleson Allen F · Granbury, TXN22AHMalchoff Keith B Jr · Yuma, CON22DRScott Aero LLC · Hudson Oaks, TXN234DDNunez Christian · Grand Prairie, TXN237KBHenke Aircraft Holdings LLC · Dayton, TXN245MBRobinson Gary O · Escondido, CAN246BWRc Sun Enterprises Inc · Loveland, CON246JDHilliard Bruce · Grantsville, UTN246TAHartman Allen L · Queen Creek, AZN24CSMcmanigle Jeffrey · Osakis, MNN25BRJames Roger · Daphne, ALN2667BBellanca Flyer Inc · Winter Garden, FLN2667MYce Consulting Inc · Easton, PAN266BNPinckney Michael M DBA · Pensacola, FLN26732Jefferies Jon F · Elk Grove Village, ILN2677ST&D Janitorial Services LLC · Dexter, MON2678ZKing Canyon Buffalo Inc · Denver, COFirst renewal notice
Back to AD 75-20-06