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.
N4401WCae Aviation Academy Phoenix LLC · Mesa, AZN44027Phelps Russell C · Naknek, AKN4402ACae Aviation Academy Phoenix LLC · Mesa, AZN4402HKressler Brendan · Coopersburg, PAN4402QSummers Mark A · Alpine, WYN4402RAvel Aircraft Inc · West Chicago, ILN4402TCae Aviation Academy Phoneix LLC · Mesa, AZN4402UCae Aviation Academy Phoenix LLC · Mesa, AZN4402XGunka Jack S · Romeoville, ILN44036Dorrobrook LLC · Lacey, WAN44037Choate Clint · Liberty Hill, TXN4403HDjm Investments Inc · Menno, SDN4403JColey Shane · Statham, GAN4403LCae Aviation Academy Phoenix LLC · Mesa, AZN4403RGorge Aviation Services LLC · Portland, ORN4403WCae Aviation Academy Phoenix LLC · Mesa, AZN4403XN4403x LLC · St Thomas, VIN4403ZCae Aviation Academy Phoenix LLC · Mesa, AZN44048Beets Larry J · Columbia, MSN4404AHanson Toby J · Webster, MNN4404JFly Like A Girl LLC · Friday Harbor, WAN4404ZChapin William V · Fayetteville, GAN4405ECae Aviation Academy Phoenix LLC · Mesa, AZN4405JCae Aviation Academy Phoenix LLC · Mesa, AZN4405KCae Aviation Academy Phoenix LLC · Mesa, AZN4405NCae Aviation Academy Phoenix LLC · Mesa, AZN4405QCae Aviation Academy Phoenix LLC · Mesa, AZN4405RBon Homme Flyers Inc · Tyndall, SDN4405TDmac Aircraft LLC · Savannah, GAN4405XW Air LLC · Wheeling, ILN4405ZLux Leon E · Hartsel, CON44060Pilatus Aircraft USA Ltd · Broomfield, CON44066Majefski Waylon C · Kingwood, TXN4406MSmith Matthew E · St Charles, ILN4406TPollard John R · Melbourne, FLN44071Aldrich Brock L · Indianapolis, INN44076Robinson Richard · Rochester, MIN4407ALange Brent W · Howard, OHN4407HHollenbeck Kim D · Mobridge, SDN4407JOsborne Kathy A · Louisville, KYN4407QSund Manufacturing Co · Newburg, NDN4407XRegistered aircraftN4407ZSoule Clauson D · Cooperstown, NYN44081Plm Enterprises LLC · Mount Washington, KYN44082Skyliner LLC · Winter Haven, FLN4408AGalloway Douglas A · Sandusky, OHN4408HHiebert Marvin R · Yelm, WAN4408JHolsen Charles A · Houston, TXN4408MGlen John Robert · Anchorage, AKN4408NLeatherheads LLC · Greer, SC
Back to AD 90-04-06 R1