AD 2000-01-16
Registered aircraft · 2,711
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:2000-01-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16')
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:2000-01-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-01-16') 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.
N188SRRogers Steven Trustee · Ogden, UTN1894EDelvest LLC · Grosse Pointe, MIN189MKS2ar Aviations LLC · Lantana, FLN18DLBelov Mikhail · Greenwood Village, CON18EGBoanco Inc · Lafayette, INN18MRMorey Airplane Co Inc · Middleton, WIN18TN18t Ltd · Wilmington, DEN18TCAviotti Inc · Henderson, NVN1905B605 Aviation LLC · Aberdeen, SDN1905ERusso Louis A Jr · Houston, TXN1908GAir Z Flying Service Inc · Richmond Heights, OHN1915WPasha Mohammad A · Muscatine, IAN1918EGuano Air LLC · Palmetto Bay, FLN1918JCoastal Satellite Inc · Woodland Hills, CAN1919LSmith Sydney O · Lithonia, GAN1920EHappy Trails Flight Training & Charters LLC · Helena, MTN1925GEfi Technology Inc · Cave Creek, AZN192AFWarren E Mack LLC · Minneapolis, MNN1942GBas Part Sales LLC · Greeley, CON1944EHans Construction LLC · Lititz, PAN1944GBas Part Sales LLC · Greeley, CON1946GPartwin421 LLC · Greenwich, CTN196CAHyannis Air Service Inc DBA · Hyannis, MAN196FSTechnical Education Services Inc · Virginia Beach, VAN197DB310 Flyers LLC · Lafayette, LAN1987GPhillips Michael M · Angleton, TXN1995GHarris Justin R · Hico, TXFirst renewal noticeN19STS&S Aviation Co · Ball Ground, GAN1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedN1QMAhlhorn Travis W · New Braunfels, TXN1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYN2002PGregory Edward · Council Bluffs, IAN200BNRubber Duck Aviation LLC · Brunswick, GAN200DCBjg Aviation I LLC · Neelyville, MON200GCDancy Abram P · Shrewsbury, MAN200MCN200mc Inc Trustee · Cheyenne, WYN200TNI & V Aviation LLC · Missoula, MTN200YCShady Aero LLC · Anchorage, KYN202AASimply Living LLC · Fort Myers, FLN202DBClipper Air LLC · Cresson, TXN202SWMar Jar LLC · Gilmer, TXFirst renewal noticeN202ZLojas Phillip · San Ysidro, CAN203JLJfra LLC · Miami, FLN204KMInternational Air Services Inc Trustee · Carson City, NVN205CAHyannis Air Service Inc DBA · Hyannis, MAN208VBas Part Sales LLC · Greeley, CON209DCDelaware Corp · Topping, VAN20EZRegistration Pending · Bigfork, MTRegistration pendingN20HKGill John H · Woodway, TXN20JNGana Trucking & Excavating Inc · Martell, NE
Back to AD 2000-01-16