AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-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:2002-07-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:2002-07-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:2002-07-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.
N72306Usda Aphis Ppq · Edinburg, TXN72309Orion Works Ltd · Denali Park, AKN72313Alaskan Air Charter LLC · Anchorage, AKN72337Gilbert Daniel Keith · Kodiak, AKN72347Hone Landscape Company LLC · Carnation, WAN72395Orion Works Ltd · Denali Park, AKN723FClear Skies LLC · Stuart, FLN72412Intricate Bay Operating LLC · Saylorsburg, PAN7247NMartin Christian E · Amagansett, NYN7250NSimon Jevon · Buckley, WAN7257NPeterson Winston Roy II · Arbuckle, CAN7267NSwalling John C · Anchorage, AKN7269NAk Air Leasing LLC · Homer, AKN726HSSpmhrt 206 LLC · East Bernard, TXN7276NDancer Aviation LLC · Delphos, OHN727FValiair Ltd Co Trustee · Casper, WYN727FACorporate Services LLC · Baton Rouge, LAN727FKVan Schoonhoven Peter · Battle Ground, WAN727NEDeeair Ltd · Dayton, OHN727WSRobey Sean C · Camden, NCFirst renewal noticeN728United States Department Of Interior · Boise, IDN72VVBank Of Utah Trustee · Salt Lake City, UTN73036Johnson Deborah K · Fairbanks, AKN7303NJordan James D · Paradise, TXN73047Spernak Airways Inc · Anchorage, AKFirst renewal noticeN7304NCoastal Aviation Export LLC · Wilmington, DEN7305URyan Air Inc · Anchorage, AKN73067Grant Aviation Inc · Anchorage, AKN73100Alaska Air Taxi LLC · Anchorage, AKN73123Lake Clark Air Inc · Port Alsworth, AKN731BJArmis Strategies LLC · Hartwell, GAN731CBAnesthesia Aviation LLC · Leesburg, VAN731CYSan Diego Air Service · San Diego, CAN731DSYou And Me LLC · Sedalia, MON731FEJones Marilyn W · Collinsville, CTN731FKQualitair LLC Trustee · MichelstadtN731FTMillican Clifford A · Burleson, TXN731GCLavalley Asset Management Inc · Potsdam, NYN731HRBrennan Timothy · San Francisco, CAN731HTAeolus Aviation LLC · Franklin, TNN731HWOne Hotel Whskey LLC · Hugoton, KSN731HYM&S Equipment Leasing LLC · Dalhart, TXN731JGGate Air LLC · Ketchum, IDN731JXKai Herbert DBA · Rillito, AZFirst renewal noticeN731KLMullen James P Jr · Rogers, ARN731KMMartin Rick H · Las Vegas, NVN731LNEastern Washington Ambulatory Anesthesia Svcs Pllc · Walla Walla, WAN731LTDodson International Parts Inc · Rantoul, KSN731LUDiversified Air LLC · Kalispell, MTN731MJLake Chelan Helicopters LLC · Manson, WA
Back to AD 2002-07-01