AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N17ADOlear Daniel J · Warren, MIN17AFRolle Caraine A · Cypress, TXN17AJJohnson Vernon G · Fort Worth, TXN17AKFrancis Joseph · Kure Beach, NCN17ARDer Kazarian Peter · Holden, MAN17AUHyatt Roy P · Coeur D Alene, IDN17AVWestchester Flying Club Inc · Purchase, NYN17BMNavigation Leasing LLC · Castle Rock, CON17BYSudac Ivan · Boise, IDN17CGOtt Kevin Dean · Orange Park, FLN17CLRaymond Justin E · Descanso, CAN17CRDawn Aviation LLC · Pierce City, MON17DKDiamond B Farm Inc · Gamaliel, KYN17DLPonderosa Aviation LLC · Safford, AZN17DSHilty Robert W · Wheatland, WYN17EMSegerstrom Ricky G Trustee · Grandview, TXN17FRNoe Aviation Ok LLC · Watonga, OKN17FVStoltzfus Shawn D · Lancaster, PAN17GCDavis Michael D · Danville, VAN17GEJet Nance LLC · Saline, MIN17GMNorthwestern Michigan College · Traverse City, MIN17GTBarnes Albert A · Jupiter, FLN17HDAlcorn Margaret Aven · Simpsonville, KYN17HPState Of Ohio Dept Of Public Safety · Columbus, OHN17HYMorong William G · Lincolnville, MEN17JFWorley William N IV · Ormond Beach, FLN17KHHubatch Kenneth A · West Bend, WIN17MCMaplecross Wealth Management LLC · Cookeville, TNN17MDMoyer David · Katy, TXN17MVNorthwestern Michigan College · Traverse City, MIN17NJCivil Air Patrol Inc · Maxwell Afb, ALN17NLAerospatial Systems LLC · Boulder, CON17PFlying M LLC · Reno, NVN17PDSelph William D · Broxton, GAN17PEEberle Paul R · Topanga, CAN17PQStory Brian J · Noblesville, INN17PWPastron Willard P · Camano Island, WAN17PZPro-Air Of Oakland Inc · Birmingham, MIN17RABrisbin Robert · Melbourne, FLN17RNOgopogo Foundation · Sonora, CAFirst renewal noticeN17SEcho Sierra LLC · Lawrenceburg, TNN17SLTastad Joel M · Hager City, WIN17TARetired Aviators Flying Club LLC · Oklahoma City, OKN17TGGeesman John T · Mason City, IAN17WAKaestner Henry Todd · Franklin, TNN17WEMckinney Joe M · Tuscumbia, ALN17WJAngel Wings Flyers LLC · Wilson, NCN17WKOhnigian Steven P · Castle Rock, CON17XCState University Of Iowa · Iowa City, IAN17YSJoslyn Larry J · Las Vegas, NV
Back to AD 2006-10-21