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.
N5318ABuchanan Harvey · Townsend, MAN5318VTyson Ron A · Fredericksburg, TXN531ECBlue Jets LLC · Rialto, CAN5323URio Farms LLC · King City, CAN5325YBeehive Telephone Co Inc Nevada · Lake Point, UTN532CHWhedbee Donald Justin · Conroe, TXN532DGRio Farms LLC · King City, CAN5336YBlue Sky Inc · Lone Rock, IAN5337YClement Aviation Inc · Tea, SDN5338AThompson Richard T · Wilmington, OHN5338UWatermelon Packer Ll · Mcallen, TXN533KAKamaka Air LLC · Honolulu, HIN5340WHebel Ryan · North Potomac, MDN5340YCripe Michael L · San Luis Obispo, CAN5348UC3 Shadow LLC · Columbus, OHN5348YWheeler Robert T · Silt, CON5358UMadson Chris · King City, CAN5359APalo Duro Aircraft Services Lc · Mckinney, TXN535AKWilson Thomas Henry III · Anchorage, AKN535MESky West Aviation Inc Trustee · Albuquerque, NMN5362AFerguson Lynn D · Alpine, WYN5363ULefore Jeffry Thomas · Milton Freewater, ORN5368AValiair Limited Co Trustee · Casper, WYN5368UBornwasser Louis W · Prospect, KYN5369AMartens Charles H · Nokomis, FLN5369YPollard William Edward · Big Spring, TXN536WCN8qb LLC · Thief River Falls, MNN5370UPogany Steve C · Anchorage, AKN5371XMarks Max · Cape Elizabeth, MEN5378PBlue Skies Today LLC · Eagan, MNN5379ABrechtelsbauer Paul · Farmville, NCN5383ASummers Timothy P · Rincon, GAN5386ATriplett And Adams Transport Partnership LLC · New Concord, OHN5388YValiair Lc Trustee · Casper, WYN5391ASingh Amandeep · Stockton, CAN5394XL K Hollenbeak Logging Inc · Hayfork, CAN5395VCortez Flying Service Inc · Cortez, CON53SGJecker Scott W · San Marcos, TXN53TMSmith Douglas M · Hackettstown, NJN5400VWilson Darryl M · Granger, INFirst renewal noticeN5401AHeadon Richard · Chino Hills, CAN5401XBarbera Frank M · Edgewood, NMN5404WBas Part Sales LLC · Greeley, CON5409YLee Christopher · Katy, TXN5411AMarc Aircraft Holding LLC · Soldotna, AKN5411XUsda Aphis Ppq · Edinburg, TXN5416UU S Department Of Agriculture · College Station, TXN5416YKer Holdings LLC · Henderson, NVN5417YFeldner Mark A · Schererville, INN5424AFudurich David E · Goleta, CA
Back to AD 2002-07-01