AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N42EREmbry-Riddle Aeronautical University Inc · Prescott, AZN42FKWinged Ambition LLC · Chandler, AZN42FYSchwartz David W · Labelle, FLN42GFGillespie Dennis M · Orange Park, FLN42GTThun Karl · Graham, WAN42HCRegistered aircraftN42HJSprenger Steven J · Fargo, NDN42HYJmfr Aviation LLC · Dallas, TXN42JAJersey Aero Club Inc · Lakewood, NJN42JTFiltersource LLC · Fort Collins, CON42KANorth Little Rock Air Inc · North Little Rock, ARN42KDDannenberg Paul A · Zeeland, MIN42KRDonnelly Charles A · Browns Mills, NJN42KSSink Kreth H · Scott Depot, WVN42LEMason County Aero Club · Ludington, MIN42LLGayden Marshall G · Wilmington, NCN42PBPfister Mark A · Acworth, GAN42PEDennis Kevin M · Bend, ORN42PMJofredo Corp · Zephyrhills, FLN42PSPrewitt Scott S · King City, CAN42PZZeidman Richard B · Cape Coral, FLN42RLChristiansen Aviation LLC · Wilmington, DEN42RRWalla Walla University · College Place, WAN42RYRagsdale Brent Nathaniel · Stockton, CAN42SPCw Air LLC · Broken Bow, NEN42TPBalkin John S · Bigfork, MTN42TYRisjan Randy D · Westfield, NYN42TZBooe Matt · Centerpoint, INN42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORN42VZCox Thomas A · Franksville, WIN42WCN42wc LLC · Rehoboth Beach, DEN42WFFrench William E · Lisbon, NHN42WVHolley Donald J · Madera, CAN42WXWeselmann Randall C · Bainbridge, INN42XCMerrill James D · Milford, VAN4300AHanna David B · Tonasket, WAN4300DNugent Michael W · New Caney, TXN4300HRasmussen Peter · Orient, OHN4300MJones Paul · Wasilla, AKN4300PMontcalm-Mcdonald LLC · Mansfield, LAFirst renewal noticeN4300RCab Air Inc · Columbia, NJN4300TPei-Ning Lo · Rowland Heights, CAN43014Woodworth Neal A · Geneva, OHN43017Conn Farms Inc · Jeffersonville, OHN4301AStevens Constance I · Homewood, CAN4301GBinkley Paul E · Lampeter, PAN4301JHarris Matthew P · Batavia, NYN4301QSchneider Frederick I · Sault Sainte Marie, MIN4301RMeggers Roger D · Baker, MTN4301XDestination 55 LLC · Cave Springs, AR
Back to AD 90-04-06 R1