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.
N7610DBug Smashers LLC · Winfield, KSN7610GFalconer Robert H · Yolo, CAN7610JDelci Dino J · Tempe, AZN7610WMeier Michael D · Naubinway, MIN7611BCason Thaddeus D · Polk City, FLN7611DLazare Luke B · Merrill, WIN7611FGeneral Aviation Support Corp · Rosamond, CAN7611GStaunton Curtis J · Tulelake, CAN7611HVezina Robert J · Rockford, MIN7611LSteils Building Renovation And Management Inc · Lino Lakes, MNN7611USchmitt Matthew A · Kenosha, WIN7611WRace Place Inc · Greenwood, INN7611YRandall Dean A · Reno, NVN7612GSwartwood Thomas C · Everson, WAN7612JSpeer Aviation LLC · Live Oak, FLN7612RSamper Aviation LLC · Easton, PAN7612WGunn Michael Reid · Wilson, ARN7613DHendrickson Aaron C · Mazomanie, WIN7613KSchramm Harold G · Utica, SDN7614DBig Bend Community College Foundation · Moses Lake, WAN7614HCommand Aire LLC · Sitka, AKN7614JN7614j LLC · Berkeley Heights, NJN7614KGoering Rodney · Hutchinson, KSN7614RKull Phillip G · Monroe, MIN7614SNatural Pleasure LLC · Fayetteville, NCN7614VTucker Aviation LLC · Kalispell, MTN7614WFerris Lawrence D · Valentine, NEN7614YSky Walker Flight School LLC · Adrian, MIN7615GWashington Samuel C · Washington, DCN7615JAll American Aviation Services Inc · Fayetteville, NCN7615WBittner Terry L · Woodbine, MDN7615ZRobinson Norman D II · Salt Lake City, UTN7616FBurgers Todd · Lagrange Hlds, ILN7616HDahmes Brad M · Hawick, MNN7616JThigpen Kevin · Jacksonville, FLN7616RMalcom Brett W · Warner Robins, GAN76172Rjd Flight LLC · North Canton, OHN76177Brown Emily D · Niceville, FLN7617DRunyan Colton C · Ashland, ALN7617FKeldahl William J · Copperhill, TNN7617HGarcia Roberto P · Spring Hill, FLFirst renewal noticeN7617JMilner Quinn D · Carbondale, ILN7617WWhirl'D Helicopters Inc · Sevierville, TNN7618KGrabousky Chad T · Halifax, PAN7618SBraun Michael T · Oconomowoc, WIN7618WExaltium Aviation LLC · Baltimore, MDN7619FAinsworth Cavin · Fort Towson, OKN7619GMercer Aviators Inc · Princeton, WVN7619KNasby Kermit R · Shelbyville, INN761AZAndover Flight School Inc · Andover, NJ
Back to AD 90-04-06 R1