AD 74-18-13
Registered aircraft · 1,642
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:74-18-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
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:74-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13') 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.
N55682Ufer Mark · Sherburn, MNN5571JHildebrandt Eric A · Cocoa, FLN5575JHarrison Matthew · Benton, ILN55776Jordan John R · Brawley, CAN5579JFlyinahrens LLC · Webster Groves, MON5581JKts Spar Bay LLC · Coral Gables, FLN5583J5150 Ventures LLC · Effingham, ILN5584JDelano James B · Laverne, CAN55856Alpha Romeo Kilo Holdings Inc · Wilmington, DEN5585JPhb Aviation Inc · Melbourne Beach, FLN5590JWilliams John S · Cleveland, TXN5592JHyden Josh Vander · Beulah, MIN5594JGirdler Robert L · Sunrise, FLN55957Blumie Thomas C · Jewett City, CTN5596JJenny LLC · Hudsonville, MIN5598JMakfly LLC · Chardon, OHN55AFRegistration Pending · Terre Haute, INRegistration pendingN56088Wild River Flying Club Inc · Saint Croix Falls, WIN56095Jk Aviation LLC · Manteca, CAN56131Qualitair LLC Trustee · MichelstadtN56143Sisson Virginia B · Houston, TXN56155Blackmon Ethan T · Hot Springs, ARN56177Bartsch Terry L · Nerstrand, MNN56194Eds Aloft Inc · Mooresville, NCN561PKKlopchic Peter G · Seattle, WAN56277Lightfoot John A · Hagerstown, MDN5627VAraujo Richard · Westport, MAN56285Knots And Attitudes LLC · Wimberley, TXN562CAG Gil Aviation Services LLC · Pompano Beach, FLN56309Des Jardins Richard T · St Joseph, MIN56320Merry Peter · Franklin, TNN56340Mja Aviation LLC · Channahon, ILN56367N56367 LLC · Manassas, VAN56392Ricottilli Stanley L · Mill Creek, WVN563PRPope County Aviation LLC · Russellville, ARN563VWRichen Owyn · Seattle, WAN56477Divelbiss Donald S · Fredericktown, OHN56510Brocon Aviation LLC · West Des Moines, IAN56527Kappel Kyle D · Crossville, TNN56613Cochran Earnest · Texarkana, TXN56631Kalbfell Kenneth · Fallbrook, CAN56655White James T · Ardmore, ALN56684Hickory Air Associates Inc · Granite Falls, NCN5668VDrb Transport Inc · Alma, MIN56709Vola Acosta LLC · Lake Forest, CAN56728Morris Air LLC · Tillar, ARN56766Elliott Scott · Holmes, NYN56793Dodson International Parts Inc · Rantoul, KSN56824Roberts Jeremy · Draper, UTN56836Spj Aviation Holdings LLC · Bentonville, AR
Back to AD 74-18-13