AD 2000-09-06
Registered aircraft · 1,273
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:2000-09-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-09-06')
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:2000-09-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-09-06') 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.
N155BHRyan John P · Kankakee, ILN156DSFanoe Nicholas J · Salinas, CAN159JDDorrance John Charles Jr · Randle, WAN15CKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN15SNRobinson Brian · Bedford, NHN164BMMachtemes Brian A · Minnetonka, MNN1653AFarmah Aviation LLC · Cary, NCN166LMFlight Rt LLC · Thonotosassa, FLN166RWGrasshopper Aviation LLC · Betsy Layne, KYN169WWPro Aire Inc · Chisago City, MNN171GSMccormick Gregory W · Athens, ALN171HSHenderson State University · Arkadelphia, ARN17FRNoe Aviation Ok LLC · Watonga, OKN17MXNokes Leslie F · Los Lunas, NMN17PFlying M LLC · Reno, NVN180MAMuston Scott A · Ypsilanti, MIN180MXN180mx LLC · Sherwood, ORN180NHWells Michael G · Salado, TXN180TDHaley Ron Dr · Eugene, ORN1819BDudinsky Todd M · Eagle River, AKN181LEast Atlantic LLC · Helena, MTN181MJTrizzino James · North Pole, AKN181TAWilkerson John D · Fairbanks, AKN186SAClemente Motor Inc · Troy, NYN188DLMartin John D · Billings, MTN1895KMcroberts Josiah R · Enterprise, FLN18KULuluvg LLC · Kalispell, MTN18PRDenicola Frank · Visalia, CAN1900ZChavey Gary G · Manchester, MIN190YSalo Mark W · Poulsbo, WAN1936PSand Dollar Seaplanes LLC · Valentines, VAN195RBHess Gary Alan · Petoskey, MIN198MTDunnavant E M · Buckingham, VAN198SGLysne Scott B · Stoughton, WIN199ZSchweitzer Gregory M · Tabernacle, NJN19SDMckenney Bret K · Billings, MTN19WXSale Reported · Alex, OKSale reportedN1RWMcmahon Jeffrey C · Iraan, TXN2001UWest Coast Resources Inc · Anchorage, AKN200CWSkylake Adventures LLC · Geneva, OHN200JJVeblen Raak · Auburn, CAN200KMFabrega Teodoro A · Doral, FLN2010USkydotcom LLC · Inver Grove Hgts, MNN2012UZimlich Kaylee M · Fort Collins, CON2013UBenedict Michael T · Anchorage, AKN2020UGrant James L · Cameron Park, CAN2022USutton Aircraft Salvage LLC · Palmer, AKN2023URegistration Pending · Belton, TXRegistration pendingN2024UAlaska Wing Covers LLC · Wasilla, AKN2028UFisher Jeffrey L · Thorndale, TX
Back to AD 2000-09-06