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.
N4608FAdvanced Aerospace Consultants Inc · Boynton Beach, FLN4609MShields David C · Council Bluffs, IAN4609TLamoureux Nicholas J · Moab, UTN4609UJerden Corp · Overland Park, KSN460CABravogolf Aviation LLC · San Jose, CAN460CCAmerican Falconry Inc · Dayton, WYN460JPNewman Charles · Petaluma, CAN460SRBuchman Barry Joseph · Atlanta, GAN460WPoling Barry · Texline, TXN460WWMalibu Ww LLC · Fayetteville, GAN460YRMathias Lee R Trustee · Sebastopol, CAN4610AHorn Paul · Kodiak, AKN4610BHuber Gregory A · Medina, OHN4610KAvag Inc · Richvale, CAN4610WTen Right Aviation LLC · Abbeville, LAN4611EFife Jeffrey Ryan · Seminole, FLN4611FRandall Jason · Woodstock, ILN4612BBenson Ian M · Portland, ORN4612KChitiea Andrew D · Centennial, CON4612SWooddale Kirby LLC · Edina, MNN4612TWeaver Matthew B · Kasilof, AKN4612UBauman Raymond S · Douglas, WYN4613BSutter Richard J · Kooskia, IDN4613MMott John H · Lafayette, INN4614TOdonnell Daniel V · Dover, DEN4615SMurrer Aviation Inc · Canonsburg, PAN4615XWaters Aero-Marine Inc · South Thomaston, MEFirst renewal noticeN4616BHammond Russell E · La Jolla, CAN46173Wieckowski Jan M · Grand Island, NYN4617BTevlin Neal · Saint Regis, MTN4617EState Of Michigan · Lansing, MIN4617WSavoldelli Steven · Los Angeles, CAN4618BRegistered aircraftN4618MBedrock Siteworks LLC · Coatesville, PAN4618TWoolston Evan K · Belle Fourche, SDN4619ARegistration Pending · Bakersfield, CARegistration pendingN4619BAnderson Scott A · Lindstrom, MNN4619MNfv LLC · Helena, MTN461AJohnson James Michael · Mount Pleasant, SCN461BCB&K Leasing Inc · Nantucket, MAN461CAMach II LLC · Carlsbad, CAN461CDRiver City Leasing LLC · Lakeville, MNN461DAGrave Eugene G · Spencer, INN461DKMark Andregg Dds Pc · Tulsa, OKN461EDp Aviation LLC · Nixa, MON461MGHangar 94 LLC · Niwot, CON461SRRiechers Peter Trustee · Napa, CAN4620BRucando Matthew P · Eagle River, AKN4620YCenturion Travel LLC · Fort Worth, TXN4621MBassline Logistics LLC · Watauga, TN
Back to AD 2000-23-21