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.
N235WHTail Aero Corp · Wilmington, DEN236PTmg Investment Properties LLC · Surprise, AZN2375SLundin Lawrence D · Midvale, IDN2384SChervenak A Douglas · Smyrna, DEN2390SPowerhawk Flyers LLC · Farmington Hills, MIN23CFYr-Aircraft Leasing LLC · Bethel, AKN23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeN23SFTarhanick Timothy P · Livonia, MIN24012Grubba Gregory T · Anchorage, AKN2423SAircraft Sales LLC · Caledonia, MIN2425SPark Sung S · Marana, AZN242RYCity Management Corp · Sunriver, ORN2437UPlanetosea LLC · Doylestown, PAN2441SSzpara John V Trustee · Chesnee, SCN244HEDubin David A · Tucson, AZN2453SFilipponi-Thompson Drilling Inc · Atascadero, CAN2457UBurr Ronald E · Anchorage, AKN246CCAlaska Department Of Public Safety · Anchorage, AKN246ECKnight Air LLC · Wausau, WIN246JJlr Resources LLC · Naples, FLN246VTAkwe River Flying And Guide Service LLC · Yakutat, AKN247CBDream Machine Leasing LLC · Glenbrook, NVN247KMNorthern Lights Ventures LLC · Moose Pass, AKN2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKN2481UWilliams Jeremy · Searsport, MEN248HSLitchfield Lantz · Las Vegas, NVN2492SSierra Hotel Aircraft LLC · Wilmington, DEN2498SKatz Michael R Trustee · Merritt Island, FLN249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN24CHDagostini Robert A · Mount Aukum, CAN24HSSandoval Ernest D · Cave Creek, AZN24NHBeyer Roger · Paw Paw, MIN24SCGriffin Samuel C · Doniphan, MON24TBDalks Leasing Inc · Wilmington, DEN24WWPark Avenue Group Inc · Stuart, FLN2501SGonzales Gerald · Dallas, TXN2506SByers Roger G · Lake Elmo, MNN2508SErnst Don A · San Luis Obispo, CAN2525XTolbert Mark A · Canandaigua, NYN252SWSymns Robert A · Aguila, AZN2538SBarbo Walter A · Aurora, CON254SWalker Curtis · Lake Havasu, AZN254TSGiesbrecht Nolan R · Burns, ORN2550SGrewal Amritpal S · Stockton, CAN2563SClements Kenneth Brian · Las Vegas, NVN256TETimberline Excuvation Inc · Fairbanks, AKN2572SGwin Bryan · La Porte, TXN2573QJayviation Inc · Lake City, FLN257SPAviatzone LLC · Fort Lauderdale, FLN2580SArizona Production Machinery & Supply · Casa Grande, AZ
Back to AD 2002-07-01