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.
N4695YSnider Scott E DBA · Turner, MTN46962Soto Del Carpio Nhikitoa · Fairbanks, AKN46964Simsbury Aviation Services LLC · Simsbury, CTN4696FTorres Roberto · Bavamon, PRN4696JRegistered aircraftN4696LKoontz Marina M · Seattle, WAN4696RSchroter Jon A · La Crosse, KSN4697RHolthaus Cody · Eden Prairie, MNN4697WKellermeyer Steven B · Tucson, AZN4697ZAntesberger Edward A · Fairfax, VAN46983Smale Christopher Cotrustee · Bakersfield, CAN4698DDrm Aviation LLC · Glencoe, ALN4698FSmith Marciano S · Fort Lauderdale, FLN4698JShea William Preston · Franklin, TNN4698MTri-County Sprayers Inc · Hamlin, TXN4699JBeach Robert E · Fairfax, VAN4699RGillis Jeremiah · Cody, WYN469AKWells Kris G · Barron, WIN469DKKimbrough Duke III · Rhome, TXN469FAStratus Rr LLC · New Castle, DEN469FSSunderland Richard · Matthews, NCN469GWRegistered aircraftN469JHHolland John R · Jacksonville, FLN469JJTesmer Dean D · Rio, WIN469JSToole William B · Goochland, VAFirst renewal noticeN469KLM9 Flight LLC · Delhi, LAN469NETauber Samara R · La Jolla, CAFirst renewal noticeN469RAChorice Kenneth · Bartlett, TNN469RHShaughnessy Thomas E · Seabrook, NHN469SMMyres Mark D · Freeland, WAN469TFHalf Penny Hangar Inc · Houston, TXN469TWEmge Douglas W · Albertville, ALN469YMyburgh Hendrick T · Petaluma, CAN46AArcher Jimmy R · Houston, TXN46AARutan Aircraft Flying Experience · Waller, TXN46ABSchultz Lawrence D · San Diego, CAN46AHDobbs Joseph D Jr · Charlotte, NCN46AJPosson John L Trustee · Petaluma, CAN46APMorris Christopher J · Crockett, TXN46ATBurcar Mark L · Gig Harbor, WAN46BEvans James · Tuolumne, CAN46BVPellerin Brian · Hermon, MEN46CCCravens Clarence C · Fairview, OKN46CTBurns Donald E · Corning, CAN46DAPotts Timothy W · Oscoda, MIN46DCMonberg James · Seattle, WAN46DHMusgrave John R · Morris, ILN46DZLuepke Quinn L · Wasilla, AKN46EAEssential Aviation LLC · Meridianville, ALN46ETNicholson Jim · Cody, WY
Back to AD 90-04-06 R1