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.
N1042DCarson Roger K · Anthem, AZN1042JJac LLC · Denham Springs, LAN1042LHale Cynthia G · Upper Black Eddy, PAN1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCN1042XN1042x LLC · Papillion, NEN1042ZMatthews Casey B · Belmont, NCN10438Czerwonka David E · Rumford, RIN1043JLanmon Herman Jr · Hamilton, TXN1043QRegistered aircraftN1043XAustin Security Corp · Battleboro, NCN1044FNottorf Eric W · Keller, TXN1044JNagasaka Bruce J · Weiser, IDN1044LFitch Mark · Anchorage, AKN1044NMaule Flight Inc · Moultrie, GAN1045Paragon Airplane Leasing Co · Fort Myers, FLN10457Six Ten Ventures LLC · Cedar Hill, TXN1045LBernard Robert J · Millbury, MAN1045RKersting Thomas J · Volga, SDN1045YRovers Bradley S · Chazy, NYN1046BOglesby Jonathan D · Okmulgee, OKN1046ERisk Indemnification Professionals LLC · Boston, MAN1047JFirst Flight Investments LLC · Bartow, FLN1047NMccormick William R · Louisville, KYN1047UStueve'S Certified Organic Dairy · Oakdale, CAN1047YDonato Deleonardis · Paulden, AZN10480Piper 66 LLC · Kirksville, MON10481Marshburn Leroy D III · Kernersville, NCN1048DDumbravo Dustin C · Yorktown, VAN1048FWard Anthony · Paige, TXN1048LSparrow Thomas E · Hawley, MNN1048QTaf Aerial Services LLC · Corpus Christi, TXN1048TTrotter Thomas J · Bremerton, WAN1048XLogan Colton Dean · Pagosa Springs, CON1049JLoxley Jason C · Virginia, ILN1049TRoberts Kevin C · Athens, GAN1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeN104AHickman John E Jr · Coronado, CAN104AAMeridian Aircraft LLC · Wilmington, DEN104ABPeterson Kevin D · Peoria, AZN104ACRoss Stephen D · Greenfield, OHN104AFNance David B · Quinton, VAN104ALDinardi Allen J · Jacksonville, ORN104AZJarrell Rodney M · Phoenix, AZN104BCHoudek Todd L · Roseburg, ORN104BKCharlie Alpha Bravo LLC · Spring Hill, KSN104BRBelsaas Richard A · Rapid City, SDN104CAMeggers Roger D · Baker, MTN104CCN104cc LLC · Fredericksburg, TXN104CDOlson Timothy D · Elk Mound, WIN104DFHayton Thomas M · Arcadia, OK
Back to AD 2012-19-01