AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N367PTHalcomb Robby · Burleson, TXN367TMTm Ventures LLC · Missoula, MTN36847Thrash Howard G II · Lubbock, TXN3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeN3685WJewell Warren · Seattle, WAN36862Linville Keith · Bend, ORN36877Stilwell Aviation LLC · Stilwell, KSN36884Main Aviation Inc · Visalia, CAN36885Sky West Aviation Inc Trustee · Albuquerque, NMN36887Aa Aircraft Adventure LLC · Joplin, MON368CDSavfar Aviation Inc · Wilmington, DEN368CMKraemer Jeffrey J · Cold Spring, MNN368DMNosrati David · Beverly Hills, CAN368FDOakes Farms Food & Distribution Services LLC · Naples, FLN368MWAvalanche Aviation LLC · Ogden, UTN368POfferaire Inc · Lebanon, NJN368RMCirruslydm LLC · Helena, MTN368TTFlorida Life Aviation LLC · New Smyrna Beach, FLN36908Williams D Eric · Palm Springs, FLN3690DR B M Corporation · Cropwell, ALN3690NDetraglia Michael C · Canandaigua, NYN36911Hyannis Air Service Inc · Hyannis, MAN36939Holtzen Farms Inc · Jerome, IDN36958N36zz LLC · Parkland, FLN36961Alpha 414a LLC · New Smyrna Beach, FLN3696LP51d Mustang LLC · Bigfork, MTN3699GInternational Aerospace Solutions LLC · Jupiter Inlet, FLN369BETeel Air LLC · Horseshoe Bay, TXN369CHLiberty Leasing Ix LLC · Melbourne, FLN369HCCornerstone Mapping Inc · Roca, NEN369JDVitale Baxter 2 Llp · Baxter, MNN369PCPine Holdings LLC · Broken Bow, OKN369PRVan Bortel Aircraft Inc · Arlington, TXN369PSPb&J Aloft LLC · Talking Rock, GAN369SACaton William D · Irving, TXN369SESkyfusion II LLC · Atlanta, GAN369SFFlying Pig Express II LLC · Bucyrus, OHN369ZDZelta Air LLC · Newark, DEN36AJFurst A J · Coral Gables, FLN36ARArkansas Department Of Aeronautics · Little Rock, ARN36BKBiro Manufacturing Co Inc · Marblehead, OHN36BXCirrus Design Corp · Duluth, MNN36CGDay Edwin Daniel · Richland, WAN36CTExecutive Mission LLC · Round Rock, TXN36CZHvr Air LLC · Zionsville, INN36DGRegistered aircraftN36EKLobo Aero LLC · Mansfield, TXN36FESeenikkib Real Estate LLC · Lakeland, TNN36FFGarr Aero Inc · Bedford, TXN36GJSweet Aviation LLC · Fort Wayne, IN
Back to AD 2012-10-13