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.
N123CVVerhage Carroll L · Geneva, NEN123CXMcinnes Donald Scott · San Anselmo, CAN123DKGetsinger Nolan B · Idaho Falls, IDN123DSDenton Farms LLC · Williamsburg, MIN123EJHughey Mark · Rogersville, ALN123ESPlane Fun Inc Tr Trustee · Snellville, GAN123FAGlas Robert Sean · Lompoc, CAN123FKSchumacher Perry W · Clearwater, FLN123FLPiper Aircraft Inc · Vero Beach, FLN123FRRoyal Air Flying LLC · Colorado Springs, CON123GCParsons John · Winter Park, FLN123GEFlying Four Inc · Saint Petersburg, FLN123GG150th Aero Flying Club · Morristown, NJN123GHMoyers Jeff · Troy, VAN123HCBooher Gregory F · Mena, ARN123HMComanche Air LLC · Mokena, ILN123HUDriscoll Jeffery D · Aberdeen, IDN123HXHankins Shannon G · Tulsa, OKN123JPPetri James P · North Adams, MAN123KCHelms Brandon M · Indian Trail, NCN123KW123 LLC · Allentown, PAN123LMMccleary Bryan W · Marion, OHN123MFAronhalt Daniel E · Columbus, INN123MVEmerald City Aircraft Leasing Inc · Port Orchard, WAN123NADecker Family Aviation LLC · Conroe, TXN123PAFly For Fun Inc · Niceville, FLN123PFJet Air Inc · Iowa City, IAN123PGFinlayson William S · Annapolis, MDN123PPHyman Martin Am · Saunderstown, RIN123PTScheller Erik G Trustee · Gig Harbor, WAN123PVSandlapper Aviation Of De Inc · Bennington, VTN123RMConstruction Imports LLC · Fleetwood, NCN123RVMarshall Jerry D · Hachita, NMN123SCScott Shawn C · Granbury, TXN123SPMain Wesley Jake · Kenai, AKN123SQCesare Anthony D · Millinocket, MEN123SRSwilley Eric S · Kurtistown, HIN123SWBelschner Custom Meats · Amherst, NEN123TAAshcraft Todd W · Elgin, ILN123TEVirgil W Young Jr Pa · North Little Rock, ARN123TJClover Management Systems Inc · Sanford, FLN123TRUltimate Aerosports LLC · Seminole, TXN123TVIn Flight Aircraft LLC · Howell, MIN123TXGofly Corporation · Port Ewen, NYN123TYNorrish Tyler E · Grapeview, WAN123TZSouthside Truck And Trailer Inc · San Antonio, TXN123UASchlabach Sharon · Lakewood Rch, FLN123VKAtp Aircraft 1 LLC · Wilmington, DEN123VMRegistered aircraftN123WAAshem Aviation LLC · Wilmington, DE
Back to AD 2006-10-21