AD 2000-23-21
Registered aircraft · 47,133
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-23-21')
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-23-21')
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-23-21') 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-23-21') 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.
N368RMCirruslydm LLC · Helena, MTN368TTFlorida Life Aviation LLC · New Smyrna Beach, FLN368VKranz Daniel · Hastings, MNN36900Bas Part Sales LLC · Greeley, CON36908Williams D Eric · Palm Springs, FLN3690DR B M Corporation · Cropwell, ALN3690NDetraglia Michael C · Canandaigua, NYN36911Hyannis Air Service Inc · Hyannis, MAN3691YHunt Lynn C Trustee · Windsor, CAN3692ABva Bonanza LLC · Keizer, ORN3692CDevil Dusters Inc · Artesia, NMN3692UPineview Ac Sales LLC · Bedford, WYN36939Holtzen Farms Inc · Jerome, IDN3693AC And F Enterprise L L C · Milford, MIN3694LRegistered aircraftN3694UPara Tactics LLC · Shelton, WAFirst renewal noticeN3694YScott Dale D · Alliance, OHN36958N36zz LLC · Parkland, FLN3695LBg Aviation LLC · Waukesha, WIN3695NWalton Jerry Prince Jr · Monticello, FLN3695YAffordable Aviation Corp · Moriches, NYN36961Alpha 414a LLC · New Smyrna Beach, FLN36968Msb Aviation LLC · Middletown, DEN3696LP51d Mustang LLC · Bigfork, MTN3698CTomlinson John J · Kent, WAN3698D98d Aviation LLC · Dyersburg, TNN3698UJk Fly LLC · Abie, NEN3699AWeskap Hangar Management LLC · West Grove, PAN3699GInternational Aerospace Solutions LLC · Jupiter Inlet, FLN3699HBarnhardt Jerry · Stockton, CAN3699YAmfreight Logistics LLC · Deltona, FLN369ACAircraft Guaranty Corp Trustee · Oklahoma City, OKN369ALInternational Air Services Inc Trustee · Carson City, NVN369BETeel Air LLC · Horseshoe Bay, TXN369BWHilliard Richard W · Southern Pines, NCN369BYVito Air Inc · Wilmington, DEN369CHLiberty Leasing Ix LLC · Melbourne, FLN369CMOharra Robert J · Buckley, WAN369GGulley Cameron L · Eastland, TXN369GTTokar Gary J · Howell, MIN369HCCornerstone Mapping Inc · Roca, NEN369JDVitale Baxter 2 Llp · Baxter, MNN369JMAircraft Guaranty Corp Trustee · Oklahoma City, OKN369KSkydive Inc · Eagle Creek, ORN369KMHoon David DBA · Wolf Creek, MTN369MMurrell James Sr · Douglas, AZN369MBBarnes Matthew L · Pacific Palisades, CAN369PCPine Holdings LLC · Broken Bow, OKN369PRVan Bortel Aircraft Inc · Arlington, TXN369PSPb&J Aloft LLC · Talking Rock, GA
Back to AD 2000-23-21