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.
N86FPGateway Flight Center LLC · Port Lavaca, TXN86GMMcguire Michael D · Lake Stevens, WAN86GPNichols Clint T · Tehachapi, CAN86HFSkillman Michael W · Brookshire, TXN86HGHeikes Tim D · Dakota City, NEN86HLGalpin Henry M · Kalispell, MTN86HWWalker James J · Santa Clara, CAN86HYBock Roger · Williamsville, ILN86JJFelda Farms LLC · Felda, FLN86JPZeitner Charles M · Palermo, CAN86KYMartin Jay L · Tijeras, NMN86LEHarris Robert W · Covington, TNN86LKKoinzan Flying Serv Inc · Elgin, NEN86LMFields David B · Midland, TXN86MKStinson Jeffrey S · The Villages, FLN86MLLam Aviation Inc · Los Altos Hills, CAN86MMMuir Malcolm D · Quincy, CAN86PTAlejandro Garduno · Livermore, CAN86RAAcrodocs LLC · Tallahassee, FLN86RHGross Richard · Phoenix, ORN86RLGreen Aviation LLC · Hedgesville, WVN86RTInverted Aviation Inc · Walnut Cove, NCN86SADureiko Martin J · Miami, FLN86SDYoung Randall K · Clearwater Beach, FLN86SMChase Aero LLC · Darrington, WAN86TDGuimont William P · Lynnwood, WAN86TFPickren Craig W · Batesville, ARN86THWeems Winceslas Scott · Columbia, SCN86TTThomas Mathew A · Wichita Falls, TXN86TUFosaaen Karl · Albany, ORN86UFWarden Richard L · Canby, ORN86VBAce Flight Center · St Thomas, VIN86WCBufkin Cayce · Hickory, MSN86WDJasmer Jody M · Lake Stevens, WAN86WJWalbridge James S · Mill Hall, PAN86WKAmick Michael K · Franklin, TNN86WSPlane Fun Inc Tr Trustee · Snellville, GAN86WYMcmahon Thomas J · Missoula, MTN86ZZSchermer Jacob D · Denver, CON87006Dow Terry D · Okarche, OKN87008Garrity Frank B · Durham, CAN87009Wrench Heath · Lafayette, CON8700FHouston Police Department · Houston, TXN8700NJones Jaycob Paul · Arlington, TXN87015Legacy Lsa LLC · Lubbock, TXN87019Bates Paul L · Livermore Falls, MEN8701DHopman Elizabeth Trustee · Quincy, CAN8701NFuellner Frederick E · Shelocta, PAN8701YSobelman Jack G · Yorba Linda, CAN87021Haugen Delos L · Burlington, ND
Back to AD 90-04-06 R1