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.
N67375T Craft Aero Club · Nampa, IDN6737JWalt Richard A · Whittemore, MIN6737NCox James G · Yankton, SDN6737PEhni Scott M · Trinity, TXN67381Leustek Thomas A · Willow River, MNN67383Glover Matthew B · Seaboard, NCN67384Flying Twenties Inc · San Jose, CAN67387Florida Flight Training Center Inc · Venice, FLN6738WRussell Christopher E · Pontotoc, MSN67398Jet & Rotor Aviation LLC · Sacramento, CAN6739BDeal Stuart F · Santa Rosa, CAN6739JRafferty Larry M · Mount Vernon, OHN6739NMeyer Ross · Apollo Beach, FLN673ACCook Andrew S · Sheridan, INN673ASRodriquez Adrian · Miami, FLN673CTCentral Texas College · Killeen, TXN673DWSunrise Aviation Inc · Ormond Beach, FLN673HHaddix Daniel R · Buena Park, CAN673JFHall Matthew P · Fowlerville, MIN673LJLegg Daniel T · Knoxville, TNN673MALewis University · Romeoville, ILN673SCSpartan Education LLC · Tulsa, OKN673SP673sp LLC · Blaine, MNN67405Cal Aggie Flying Farmers Inc · Davis, CAN67407Reeb Franklin B · Montross, VAN6740LAslesen Leasin LLC · Halstad, MNN6740NGraham Bruce A · Port Saint Joe, FLN6740UJust Air LLC · Victorville, CAN67410Sky Chiefs Aviation LLC · Gainesville, FLN6741BPoehler Fred G · Newberg, ORN6741LMountain Aviation Corp · Mccall, IDN6741PBall William E · Amarillo, TXN6741TCavanaugh Flight Museum · Denison, TXN67420Coor Colin F · Honolulu, HIN6742JGannone Nanette V · El Prado, NMN6742WMidnight Flight LLC · Wells, TXN67431Robinson Candace A · Long Beach, CAN6743FHollywood Biplane LLC DBA · Atlanta, GAN6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCN6743JStader Noah M · Platteville, WIN6743NHollingsworth Michael J · Phoenix, AZN67440Walford Richard M · Shreveport, LAN67443Air-O-Drome Aviation LLC · Caldwell, IDN67444Odell Eugene S · Yakima, WAN67448Classen Linda · Mustang, OKFirst renewal noticeN6744DDyer Randall J · Frazier Park, CAN6744NVan Benschoten Mark T · Linwood, MIN6744UMelia Alexander A · Jacksonville, FLN67452Larkin Lucia V · Salome, AZN67454Naff Peter B · Memphis, TN
Back to AD 90-04-06 R1