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.
N3987WPhipps Robert Sean · Euless, TXN3988WGrant Robert M Trustee · Farmington Hills, MIN3989WHigher Plane Inc · Wilton Manors, FLN3989XEdgar Mary E · Butler, TNN3991WAllways LLC · Missoula, MTN39941Devoll Jeffrey · Sacramento, CAN3994WKramer Jeffrey P · Burlington, WIN3997FMatthews David L · Floyds Knobs, INN3997WJaroch Eric J · Houghton Lake, MIN3999XK-Viation LLC · Paulding, OHN399LMPepper LLC · Winter Garden, FLN399RCSouthwestern Development & Leasing Inc · Costa Mesa, CAN3BSEcho 7 Tango Aviation LLC · Pottsboro, TXN3FNFreedom Wings LLC · Spout Spring, VAN4001RPrusso Douglas M · Woodstock, GAN4002WBall David J · Shreveport, LAN4003RRowley Stephen A · Burlington, WIN4004RHoche-Mong Michel · Campbell, CAN4004WWatson Worldwide LLC · Buzzards Bay, MAN4009RFagerberg Albert · Hot Springs Villag, ARN4010WOne Zero Whiskey LLC · Savannah, GAN4011RHot Shots Aerial Photography LLC · Mesa, AZN4011WAdami Devin · Truckee, CAN4015RJ And J Av8 LLC · Eatonton, GAN4016RNorsworthy Aviation LLC · Redington Shores, FLN4018RRyan Jeromie · Allen, TXN4019RFdmas LLC · Bellevue, WAN4019WSmith Timothy A · Granbury, TXN4020RDemers James D · Firestone, CON4020WRoss Hx LLC · Lebanon, OHN4021R21 Romeo Inc · Horton, MIN4021WClark Darrell E Jr · Edna, TXN4022RZ Aviation LLC · North Ridgeville, OHN4024RCheuvront Jevon K · Seminole, TXN4025WMcgee Mark K · Port Alsworth, AKN4028WCmor Properties LLC · Saint Augustine, FLN4029WBadger 29w LLC · Waukesha, WIN4030RDsp Investments LLC · Long Beach, CAN4032WRegistered aircraftN4033RSwanson Terence S · Montrose, CON4033WHolladay Grant L · Lamesa, TXN4034RBryant Jonathan E · Joaquin, TXN4042RSutton Aircraft Salvage LLC · Palmer, AKN4044RFour M Aviation LLC · St Petersburg, FLN4048RHarris Heights LLC · Tyler, TXN4051WHenningsen Gregory Mark · Arvada, CON4053RDorsett Brandon · Buckeye, AZN4055RBroadhurst Eric Clark · Brookline, NHN4055WDiehl Frances M · Alamogordo, NMN4056WHighwing Flyers Inc · Cape May Ch, NJ
Back to AD 74-18-13