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.
N85LWPlanenuts LLC · Boulder, CON85MANorthcutt Allan C · Broomfield, COFirst renewal noticeN85MBBradley Max T II · West Plains, MON85MCFrasier Samuel R · Gainesville, FLN85MDPair Chris X · Fletcher, NCN85MNMack Air LLC · Anchorage, AKN85MPPitman Marvin L · Harrah, OKN85NAHampden Aviation Services Inc · Northampton, MAN85NPSamayoa Rodolfo T · San Dimas, CAN85PWAnderson John C · Lake Geneva, WIN85RCKalvoda Charles B · Mandan, NDN85RGBolton William M · Waxahachie, TXN85RSQualitair LLC Trustee · MichelstadtN85RVKadlubowski Michael J · Colorado Springs, CON85RWJkg LLC · Murfreesboro, TNN85SBSnk Acft Enterprise LLC · O Brien, FLN85SDToledo Cowboys LLC (Mi) · Adrian, MIN85SPBurkett Jacob E · Polk City, FLN85TMErwin Matthew Lee · Georgetown, INN85TTHerbert Henry W · Lake Stevens, WAN85TXBrown Judy C · Fredericksburg, TXN85TYYoung Thomas M · Homer, AKN85VAAvro Ltd · Grand Junction, CON85WABeckwith James N · Goldsboro, NCN85WEBrooks Matthew · Norman, OKN85WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN85WYDouble L Air LLC · Missoula, MTN85ZZSpeed Products LLC · Missoula, MTN8600CFowler Leo W · Port Alsworth, AKN8600DPockrus Pat B · Mineral Wells, TXN8600XR1 Aviation LLC · Lake Havasu City, AZN8600YMontcalm Kevin L · Mansfield, LAN8601Lewis Richard F · Halifax, VAN8601AWhitaker Alvin E · Waterloo, WIN8601DRubbert Randy C · Reynolds, NDN8601PCross Robert D · Great Falls, MTN8601XHuff Air LLC · Uvalde, TXN8602CShrode Rafe C · Jewett, TXN8602DFithian Cody D · Wasilla, AKN8602KSkywagon LLC · Wilmington, DEN8602SBrodine Alan H · Rochester, NYN8602VSchumaker Daniel J · Glenville, MNN8605CColier Neal · Mc David, FLFirst renewal noticeN8605DTroxel Robert G · Parma, IDN8605NTremper John D · Newton, NJN8605VGibney Ricky D · Fargo, NDN8605YFudenberg Elevated Solutions LLC · Las Vegas, NVN8606EJ&H Aviation LLC · Middletown, DEN8607COllmann Paul W · Poplar Grove, ILN8607DDowns Benjamin S · Madison, SD
Back to AD 90-04-06 R1