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.
N6927RSavord George Kevin · Boulder City, NVN6929RShelfer Douglas · Arlington, TXN6931RFender Darrell L · Garfield, WAN6932RBoxwell Avionics · Green Cove Springs, FLN6936RKingrey William S III · Richmond, TXN6939NSky West Aviation Inc Trustee · Albuquerque, NMN6939RGalloway Kyle J · Bradshaw, NEN6944RSilcox Cleven L · Sapulpa, OKN6945RDonham William David · Odessa, TXN6946RGrosslight Gordon · Westcliffe, CON6949RElyan Aviation Inc · Palm Springs, CAN6951YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6967BChalk 2 Inc · Apple Valley, CAN6967NSand Creek Oil & Gas Inc · Edmond, OKN6970NSeitz Thomas J · Mission, KSFirst renewal noticeN6972NEnns Robert B · Cayucos, CAN6976NCenturion Capital Partners LLC · Blue Ash, OHN6977BCollins Kevin T · Roseville, CAN6979BCenturion Bravo LLC · Houston, TXN6979NArango Jorge · Mcallen, TXN6980MPetumenos Timothy James · Anchorage, AKN6993NSp Aircraft LLC · Moscow, IDN6994MParish John L Sr · Tullahoma, TNN699EEMathes Jay B · Ridgecrest, CAN699WWWallis Warren · Barstow, CAN69HZU206 Ice LLC · Pompano Beach, FLN69LEEle Motorsports LLC · Dover, DEN69PRAero Inventory LLC · Monroe, GAN69WAKeystone Aerial Surveys Inc · Philadelphia, PAN6DEE & R Properties Of Florence LLC · Ridgeway, SCN6HGBagwell Harold G · Garner, NCN6MFMission Aviation Fellowship · Nampa, IDN6NTNevada Defense Group LLC · Henderson, NVN6PDNewcomb Clint · Benton, ARN7000KCohen Phillip A · Hopkinton, MAN7000LHalstead Michael J · Gresham, ORN700RSTransavia LLC · Wilmington, DEN701MDDel Mar Aviation LLC · Algona, IAN701PSLucky US LLC · Merrill, WIN702BDaly Moses M · Underhill, VTN702TCSykes Gregory P · Arlington, WAFirst renewal noticeN7032QRegistration Pending · Oakwood, OHRegistration pendingN70506Roesner Liselotte A · Hilton, NYN70570Miel Del Rio Grande Inc · Monte Vista, CON70594Non-Typical Airplanes LLC · Malad City, IDN70595Lung Aerial Group Inc · Tustin, CAN70598Routh Lucas R · Albert Lea, MNFirst renewal noticeN707ERCrossbrook LLC · Willoughby, OHN707KWWaters Aero Marine Inc · South Thomaston, MEN707WJLandry Don T · Thousand Oaks, CA
Back to AD 2002-07-01