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.
N6492BPatno Delviny A · Daniel, WYN6492HSpernak Airways Inc · Anchorage, AKFirst renewal noticeN6492NOrmand Philip M · Tyrone, NMN6492UWisber Peter F Jr · Perkasie, PAN6492YMiller Gary Lee · Pittsburgh, PAN6493NEagle Cap Leasing Inc · Enterprise, ORN6493YNeed To Fly LLC · Yukon, OKN6495NBusiness Trip Corp Inc · Cape Coral, FLN6499NHelgren Quentin C · Oakland, CAN6501YLively Charters Inc · Summerland Key, FLN6505N3c3 Aviation Inc · Dania Beach, FLN6506GWestern Skyways Inc · Montrose, CON6506VHarper Dreams LLC · New Smyrna Beach, FLN6506ZAf Auto Group · San Jose, CAN65093Seaman Michael V · Kalispell, MTFirst renewal noticeN6517APeterson Holding Co · San Leandro, CAN6519ABreen Jerry P III · Center Point, TXN651SPNew York State Police · Latham, NYN6526MDapp Eric M · Corvallis, ORN6527PKaci Property Management Inc · Boise, IDN6529YBbd Lynch Family Lp · Houston, TXN6530YDelgado Gonzalez Hector · San Diego, CAN6531WInternational Air Services Inc Trustee · Carson City, NVN6532NN6532n LLC · Sioux Falls, SDN6534NDoxsee Joshua · Beverly, MAN6535YRichardson Jane S · San Angelo, TXN6537WSilver Eagle Holdings LLC · Jerome, IDN6538NHaynie Ray G · Auburn, WAN6542CLeonard Summers · Pleasanton, CAN6542NHill Jonathan G · Dover, NHN6544YSchwarzenberg Johannes · Helena, MTN6546NMitchell Matthew J · Penn Yan, NYN6547CJrp Management LLC · Williams, AZN6547NHart Anthony · Promise City, IAN6553YCenturion Aero LLC · Coos Bay, ORN6555YMild Charles F · Harlingen, TXN6557BFangio Mark · Mckinney, TXN6562YKp Builders Inc · Pittsburgh, PAN6567YMoeller Gerhard Walter · Goshen, OHN6568XBarnes Inc · Lewiston, IDN656MCMcintosh Justin W · Joshua, TXN6572YMoss G B · Bakersfield, CAN6582PGrand High Way LLC · Gallatin, TNN6582XMclean Bruce R · Napa, CAN6584NHartmann Wayne E · Hill City, SDN6586WMair LLC · Lenexa, KSN6588XPc Rental LLC · Ely, MNN6589MHaller Eugene Z · East Hampton, NYN6591NRickey James R · Hanford, CAFirst renewal noticeN6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 2002-07-01