AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-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:2006-10-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:2006-10-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:2006-10-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.
N201NUGolden Seal Enterprises Inc · Winchester, VAN201NVSorbi Aviation Inc · El Cajon, CAN201NWBravo Echo LLC · Eagan, MNN201NXSzajer Gregory · Catskill, NYN201NZMooney M20j Brokers LLC · Saint Charles, MON201PMarshall Christopher R · Oshkosh, WIN201PBHumphrey Richard Ingraham · Keller, TXN201PCGreatest Show Management LLC · Bee Cave, TXN201PDOlmstead Cecil Jay III · Houston, TXN201PFMooney Flyers LLC · Minot, NDN201PJBrownfield Izzy · Denton, TXN201PKMininger John · Quakertown, PAN201PNAkins Anthony · Meridian, IDN201PPRohrbach James S · Fort Lauderdale, FLN201PSEmbrey Matthew D · Murrieta, CAN201PTWells Tony · Knob Lick, KYN201PVCowan George L · Scranton, SCN201PXNecessary Richard A Jr · Rural Hall, NCN201PYRandolph Paul D · Easley, SCN201PZSmits Joel R · Crete, ILN201QAIron Wing Flying Club Inc · Shelby Township, MIN201QCDigital Outdoor Adertising LLC · Reno, NVN201QEWaters Michael C · Social Circle, GAN201QHPodd Bradley Stephen · Wilmington, NCN201QJDubritz Michael J · Dix Hills, NYN201QMNordica Group Ltd · Chicago, ILN201QRJennings Denise E Trustee · Fullerton, CAN201QVJohnson Philip H · Bluffton, SCN201QWRose James D · Fort Worth, TXN201QXRegistration Pending · Portland, ORRegistration pendingN201QYJohnson Seth M · Arlington, TXN201QZFogle Adventure Air LLC · Neeses, SCN201RMay Jack C · Conroe, TXN201RAMooney 201ra Holding LLC · San Diego, CAN201REFowler W Kirk · Longmont, CON201RFMfc Corp · Washington, DCN201RJLoyless John B · Lubbock, TXN201RLGmg Associates · Madison, CTN201RRGuthrie Edward J · Lincoln Univ, PAN201RSWilliams Ken L · Palmer, AKN201RUMoore James B · Yorktown, VAN201RWRodriguez Ricardo A · Norristown, PAN201RYTop Shelf LLC · West Fargo, NDN201RZGoller Daniel M · Grass Lake, MIN201SAQuinn Timothy M · South Haven, MIN201SFOmara Michael N · Seymour, CTN201SGPhoturis LLC · New Carlisle, OHN201SKBu James · South Pasadena, CAN201SLCooley Ben · Owensboro, KYN201SNBecker Dean · Sarasota, FL
Back to AD 2006-10-21