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.
N375JWPanthers Aviation LLC · Pikeville, KYN375LMiroyan Robert Trustee · San Jose, CAN375MF5k Management LLC · Burnet, TXN375MJJerez Mario · Coral Gables, FLN375MKIntegrity S&J Properties LLC · Amarillo, TXN375MTVan Bortel Aircraft Inc · Arlington, TXN375NDInsuring That Pigs Can Fly LLC · Tyrone, GAN375PWRyan Adrian B · Anchorage, AKN375RHyannis Air Service Inc DBA · Hyannis, MAN375RBMarinella Leasing LLC · Chandler, AZN375RRRegistered aircraftN375SBPrecision Aerobatics Inc DBA · Santa Margarita, CAN375THRbm Records And Promotion LLC · Clinton, OHN375TT4two9 Aviation LLC · Princeton, FLN375WVictory Holdings LLC · Anacortes, WAN3760BSavage David C · Austin, TXN3760YHarris Stephen T · Williamstown, KYN3761PSky Rollers LLC · Merritt Island, FLN3762KKawasaki Clyde H · Carson City, NVN3762QHarris Randal Glenn · Sedona, AZN3763QOrr Robert · San Clemente, CAN3763UHunter James C · Shelton, WAN3765MReyner Mark D · Los Lunas, NMN3765QTonry Richard Martin · Georgetown, TXN3765YBott David F · Yukon, OKN3766DFree Range LLC · Missoula, MTN3766RHarrigan Patrick · Hickory, NCN3766YPyanov Mark · Clinton, MSN3768D3di LLC · Elizabeth, WVN3769UNorthey Scott A · Mazama, WAN376BCKunz Paul C · Midway, UTN376CDWestern Chancellor LLC · Fort Worth, TXN376CPBlue Horizon Aviation LLC · Waynesboro, GAN376CWWeavers Enterprises LLC · Annville, PAN376PDStriplin Donald B · Mammoth Lakes, CAN376RHSeckel Dean · Mount Vernon, WAN376ZSummers Bruce K · Pismo Beach, CAN3770QTaylor Zachary S · Shawnee, OKN3770UPetersen Christopher Erik · Morton, ILN3770YBig Bend C C Foundation · Moses Lake, WAN3772QBoav8r LLC · Marana, AZN3772YKossuth Keith E · Sleepy Hollow, CAN3774DVandal Air LLC · Boise, IDN3774YLanning 2 Aviation LLC · Amarillo, TXN3775DRegistration Pending · Churchville, MDRegistration pendingN3776USchmit Joe · Ventura, IAN37777Quiet Aviation LLC · Longwood, FLN3777DOrchid Aero LLC · Lakewood, CON3777SStuart Guy · Owosso, MIN3778DBrownd Carl L · Oro Valley, AZ
Back to AD 2000-23-21