AD 2000-11-51
Registered aircraft · 10,473
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:2000-11-51')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-11-51')
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:2000-11-51') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-11-51') 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.
N104JHDouble Helix Solutions LLC · Kamuela, HIN104WPMartyn Christian A · Hallendale, FLN104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIN1054VNorthington Neill · Fredericksburg, TXN1054XMurphy George E · Robinson, ILN1055VWarner Alan P · Carpinteria, CAN1058VPelfrey Earl T · Crossville, TNN105RDSunny Slope Aviation LLC · Adams, TNN1064VHenderson Robert J · Grass Lake, MIN10691Reed Kerr Aviation Inc · Wilmington, DEN1069JLoomis Adra A · Weldona, CON1069VSmith Robert E · Nacogdoches, TXN106CDAerou LLC · Oviedo, FLN106LUBluewater Plumbing Service LLC · Wilmington, NCN106PKScarbrough Dean C · Deshler, OHN106QIntegrity Aero LLC · Boerne, TXN106WSMarriott Ed · Manhattan Beach, CAN1070VKrebs Michael · Elkhorn, WIN1070XMosby Group LLC · Edgerton, MON1070ZSky West Aviation Inc Trustee · Albuquerque, NMN1071JMoore Bradford H · Severna Park, MDN1071VAdvanced Disability Management Inc · Montgomery, TXN1072JAcorn Veterinary Services · Woodstock, VAN1072VHegrenes Bruce A · Duluth, MNN1073YGoedicke Walter H Jr · Bay Head, NJN1074JShevitski Jeffrey · New Castle, PAN1075JTise Marcelo D · South Hackensack, NJN1076JRichards Steven P · Lockport, NYN1076VBell Johnny S · Tokeland, WAN1077JAlttitude With Attitude LLC · Elizabethtown, PAN1077YPainter No 2 LLC · Hillman, MIN1079BMander Ronald L · Mooresville, NCN107ABHobart Aviation Inc · Akron, OHN107BLVinland Aerodrome Inc · Baldwin City, KSN107CDKhalil Hassan · Clarks Summit, PAN107DBSkymaster Stc LLC · Mena, ARN107PSLadies In Aviation LLC · Mocksville, NCN107THWheaton James G · Johns Island, SCN1082YCalvey Eric W · Abingdon, MDN10851Curran Michael F · Windham, NHN1085CBentley Geoffrey D · Marco Island, FLN1085NWong Sonja M · Alameda, CAN1086VKinney Philip S · Saint Johns, FLN1088VLeiva Lloyd · Bradenton, FLN108CCFlaugher Jonathan S · Poquoson, VAN108TSHesser Dale W · Cardington, OHN1090QArrow 051 LLC · Leicester, NCN1091NDunkin Stevan R · Emmett, IDN1091VWeeden Lee R · Lewistown, MTN1093VNewman Donald · Hemphill, TX
Back to AD 2000-11-51