AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N42VBHeli Ag LLC · Waller, TXN42VFWillits Brent E · Frankston, TXN42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORN42WBCity Of Mesa Arizona · Mesa, AZN42WCN42wc LLC · Rehoboth Beach, DEN42WDN42wd LLC · Seattle, WAN42WGEl Paso Industries Inc · Santa Teresa, NMN42WHF & F Automotive Inc · Valliant, OKN42WKMariash Cary Norman · Indianapolis, INN42WSOrlandella Vito · Auberry, CAN42WVHolley Donald J · Madera, CAN42WXWeselmann Randall C · Bainbridge, INN42WYDynamite Aviation LLC · Meridian, IDN42XCMerrill James D · Milford, VAN42ZNHuntsville Flyers LLC · Owens Cross Roads, ALN4300AHanna David B · Tonasket, WAN4300MJones Paul · Wasilla, AKN4300PMontcalm-Mcdonald LLC · Mansfield, LAFirst renewal noticeN4300QFarwell Christopher J Trustee · Olympia, WAN4300RCab Air Inc · Columbia, NJN4300TPei-Ning Lo · Rowland Heights, CAN4300VMoe Jeffery Allen Jr · Tioga, NDN4300WPrivate Enterprises LLC · Peoria, AZN43014Woodworth Neal A · Geneva, OHN43017Conn Farms Inc · Jeffersonville, OHN4301AStevens Constance I · Homewood, CAN4301JHarris Matthew P · Batavia, NYN4301LMckelvey Colt A · Canonsburg, PAN4301MHayes Feeding Company LLC · Osceola, NEN4301QSchneider Frederick I · Sault Sainte Marie, MIN4301RMeggers Roger D · Baker, MTN4301SCoburn Thomas R Trustee · Upperco, MDN4301WNash Matthew · Edmonds, WAN4301XDestination 55 LLC · Cave Springs, ARN4301ZRubbert Logan · Reynolds, NDN43020Blue Skies Flying Services Inc · Lake In The Hills, ILN43023Drs Sandra M Krokos And Thomas P Kislan Pc · Hazle Township, PAN4302MNiver Mark A · Wasilla, AKN4302TRiley Thomas J · West Grove, PAN4302WDagenhart Ronald Jason · Westerville, OHN4302YLundstedt Gregory · Duncan, SCN4302ZSportsmans Air Service Inc · Anchorage, AKN43034A S Flight Academy LLC · Lantana, FLN43037Miloud Chadd K · Fort Worth, TXN4303ANelund Craig David · Edwardsburg, MIN4303JGroff Paul F · San Leandro, CAN4303QHobart Aviation Inc · Akron, OHN4303SCartersfly LLC · Lewes, DEN4303TReem Steven J · Cogan Station, PAN43043Environmental Safety & Health Consulting Svcs Inc · Houma, LA
Back to AD 2007-04-19 R1