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.
N2125VGallagher Stephen · Delray Beach, FLN2125WWittmer Daniel J · Tucson, AZN21263Suburban Air Corp · Castro Valley, CAN2126FVista Aviation Inc · Pacoima, CAN2126WFormanek Carl F · Glen Flora, WIN2126XCandace A Learned Enterprises Inc · Long Beach, CAN21276Schrager Daniel L Trustee · Concord, MAN21279Kerry Air LLC · Wilmington, DEN2127ALockhart Michael Orian Jr · Altus, OKN2127DMetro Aircraft Co · Bloomington, MNN2127GKneeshaw Donald J · Gilbert, AZN2127PDerbenwick Gary F · Colorado Springs, CON2127RCohen Blanche F · Aurora, CON2127TGeiger Glenn M · Cincinnati, OHN21288Cunningham Campers Inc DBA · Clarksville, INN2128WDelgado David A · Fallbrook, CAN2128XWnc Aviation LLC · Arden, NCN2128YE-Cubed Industries LLC · Big Piney, WYN2129AY Naught Aviation LLC · Madill, OKN2129CFlot Group LLC · Apex, NCN2129GNorth Central Marketing Inc · Cranston, RIN2129JRidgeline Assets LLC · Wilmington, DEN2129PRehak Nathan A · Wasilla, AKN2129TSebesta Arthur J II · Winchester, KYN2129UMarzich Frank M · Rockford, ILN2129WDuknic Derek · Magnolia, TXN2129ZWelch Peter C · Carmel, NYN212BCRoberts Randall K · Clayton, NMN212BGRegistered aircraftN212BMLeaseair LLC · Wilmington, DEN212BSEuros Aircraft Leasing LLC · College Station, TXN212CKSkymates Inc · Grand Prairie, TXN212FMooney Daniel V · Malvern, PAN212FGWelch Charles E · North Chesterfield, VAN212GPWibel Enterprises Inc · Crossville, TNN212GTGrimm Daniel R · Evansville, INN212JGArndt Charles H · League City, TXN212JHHunter James A · Elizabeth City, NCN212JSCridebring Richard L · Caldwell, IDN212KMMollet Kern · Massillon, OHN212LSHeli Ag LLC · Waller, TXN212MDWashington Donald W · Lafayette, LAN212MSSuper Shine Inc · State Center, IAN212MTLindenauer David L · Boca Raton, FLN212MWColorado Mountain Leisure LLC · Sioux Falls, SDN212PDGrossman Steven J · Amherst, NHN212RGGillum Reef · Clint, TXN212SCarter Christopher L · Franklin, TNN212SCDavies Charles C · Lovettsville, VAN212STWalsh Scott · Stuart, FL
Back to AD 2006-10-21