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.
N840UBoard Of Regents Of The University Of Oklahoma · Norman, OKN84104Morris Daniel B · Ankeny, IAN84105Jost Jared D · Hillsboro, KSN84108Bramblett John S · Russellville, ARN84109Bielak Donald · Louisburg, KSN8410CLevel Up Aviation LLC · Newton, ALN8410ETito Hector · Fayetteville, GAN8410LVictory Lane Aviation LLC · Concord, NCN8410SNorth Shelby Aviation LLC · Wilmington, DEN8410WRenegade6 Aviation LLC · Woodbridge, VAN84114Miami Seaplane Tours Inc · Miami, FLN84117Mendez Arturo · Addison, ILN8411BGrohs Dihl J · Wessington Springs, SDN8411CRtb Aviation LLC · Jurupa Valley, CAN8411DElliott Frank F · Mojave, CAN8411REleven Romeo LLC · Golden, CON8411WHiggins Timothy Owen · Axtell, TXN84122Millican Marc J · Anchorage, AKN84125Koenig Aircraft Restoration Inc · Loranger, LAN84129Petschow Kenneth W · Upland, CAN8412CEiler Marc · Seattle, WAN8412LAddison Flying LLC · Addison, NYN8412RChamberlain Richard T · Collinsville, ILN8412WSutton Timothy A · Glencoe, ALN84130Gutierrez Sergio E · Pharr, TXN84133Registration Pending · Bowman, NDRegistration pendingN8413CBrown Lawrence L · Millington, TNN8413DExperimental Aircraft Association Inc · Oshkosh, WIN8413LRussell Adam G · Easton, MEN8413RZuniga Hector Javier · Mission, TXN8413WHollier Gregory J · Arnaudville, LAN8413YReinbold Frederick K · Anchorage, AKN84140Kaiser Joe E · Anchorage, AKN84141Registration Pending · Mansfield, OHRegistration pendingN84143Jones Donald T · Barrigada, GUN84146Stone Air LLC · Carrollton, GAN84147Cox James O II · Shady Shores, TXN8414CInternational Flying Club Inc · Winfield, ILN8414FPenley Robert G · Corinth, TXN8414LMorris Christopher J · Manor, TXN8414M8414m LLC · Nunica, MIN8414NAirlake Aero Inc · Lakeville, MNN8414RVick Justin M · Morton Grove, ILN8414WOhmacht Carlton J · Glenwood, MNN8414YLone Oak Aviation LLC · Greenville, NCN84151Sanders George W · Cloverdale, INN84153Spirit Air Inc · Salmon, IDN8415RMahanna John A · Radcliff, KYN8415YSchwend Brian · Forsyth, MTN84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OK
Back to AD 90-04-06 R1