AD 2012-19-01
Registered aircraft · 51,501
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-19-01')
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-19-01')
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-19-01') 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-19-01') 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.
N112BTRomero Henry Rene · Hampstead, NCN112CPBradley Aviation LLC · Columbus, INN112DGBarden John · Camp Hill, PAN112EFCommander 112a LLC · Shelburne, VTN112EXCrofton Joel R · Hohenwald, TNN112FTColesanti Richard A · Poughquag, NYN112GTGallagher Aircraft Services LLC · Dawson, PAN112HDJackson Larry D · Orlando, FLN112HYEmerald Farms LLC · Honey Grove, TXN112JJNovember Alpha LLC · Dover, DEN112JRValleau Matthew J · Wallingford, CTN112KGMedore Douglas A · Romoland, CAN112KSMattlage Kevin D · Pearland, TXN112KWYoder Neal D · Reedsville, PAN112LCJacobsen Jeffrey M · Salinas, CAN112LGAb Prop Plane I LLC · Metairie, LAN112LRRazzi Leonard F Jr · Glenmoore, PAN112LVJo Dan Motors · Plains, PAN112MGTalley Miriam S · San Antonio, TXN112NCFrance Jay D · Colbert, GAN112PHRegistered aircraftN112PZSkymaxx Inc · Daytona Beach, FLN112RJTobul James R · Jackson, WYN112RMAppalachian Aviation LLC · Harrisonburg, VAN112SGSuleman Muhammad · Dublin, OHN112SJSuchomel Chase E · North Saint Paul, MNN112SMReisdorfer Mark J · La Follette, TNN112SPMinnesota Department Of Public Safety · Saint Paul, MNN112SVGb Aviation Of Alabama LLC · Millry, ALN112TSLongo Curtis M · Crossville, TNN112TTBargainnier Devin T · Minden, NVN112UVUtah Valley University · Orem, UTN112WFWhiskey Fox LLC · Kirkland, WAN112WMInternational Air Services Inc Trustee · Carson City, NVN112WNEvans William M · Nipomo, CAN112WSEdgeington Randall K · Riverton, WYN11316Torreano Paul J · Lockport, NYN1131JStringer Greg A · Egg Hbr Twp, NJN1131LSeehafer Paul D Trustee · Junction City, WIN1131SBest Devereux Igor · Salt Lake City, UTN1132LContact Point Inc · Amarillo, TXN1132QWattum Investments LLC · Kodiak, AKN1132WC Flying K Aviation LLC · Savery, WYFirst renewal noticeN1132XWest Coast Equipment Leasing LLC · Englewood, CON11330Leikala Douglas A · Fairport Harbor, OHN1133XBristol Aircraft Leasing LLC · Willoughby, OHN11345Enviroplus Consulting Inc · Rosamond, CAN1134DFma Auto Sales LLC · Greensboro, NCN1135Plambeck Dan · Idaho Falls, IDN11359Verstegen Michael D · Bellevue, WA
Back to AD 2012-19-01