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.
N4618ESale Reported · El Paso, TXSale reportedN4618PLaguna Verde Leasing Inc · Wilmington, DEN4618VSeymour James H · Medina, OHN4618WCommander Aviation LLC · Seneca, SCN4618ZFilhart Robert · Rosebush, MIN46195Wightman Randy A · Owosso, MIN46198Palmenteri Winston D · Rhome, TXN4619RHenry Mark A · Dickinson, TXN4619VSears Wes L · Tacoma, WAN461ACTucker Gary · Georgetown, TXFirst renewal noticeN461BGDangelo John A · Dallas, TXN461CMUniversity Of Central Missouri · Warrensburg, MON461CTMarkham Reid S Jr · Louisville, KYN461DMBryn Jamie P · Dazey, NDN461EMNoll Jason · Geneva, ILN461FAStratus Rr LLC · New Castle, DEN461FMJaars Inc · Waxhaw, NCN461HHawaii Pacific Aviation Inc · Kailua Kona, HIN461JGGosch Jerry L · Missouri City, TXN461LWBent Douglas G Trustee · Stuart, FLN461PMMcmillion John T Trustee · Grand Marais, MNN461RCElicottero Rosso LLC · Missoula, MTN461RKTolstrup Dustin G · Wasilla, AKN461RMRr&D Lp · Fayetteville, NCN461TCFlorida Flight Training Center Inc · Venice, FLN461TJSharmouj Raymound · Christiansted, VIFirst renewal noticeN46200Larsen Delaine E · Wakarusa, INN46201Lakes Area Aviation LLC · Little Falls, MNN46203Avian Leasing LLC · Bremerton, WAN46204Ms Tango LLC · Phoenix, AZN46205Jeanes Michael W · Newbury Park, CAN4620HMay Kenneth D Sr · Sandy Hook, MSFirst renewal noticeN46210Cloud Dancer Aviation Inc · Deland, FLN46211Carver Clarence K Trustee · Lutz, FLN46214Greaves Ricky W · Arlington, TXN46219Diehl Samuel A · Hamptonville, NCN4621DW Tech Consulting Inc · Wilmington, DEN4621JSudor Janet · Lancaster, PAN4621RVides Jose F · La Puente, CAN4621ZGodbold Donald W · Camden, ALN46221Collins Kellie Lynn · Muskegon, MIN46226Tye Darren · Tulia, TXN46227Lindsay Lori K · Kenai, AKN4622RZimmerschield Paul T · Sedalia, MON46230Owen Collins · Toccoa, GAN46231Hibdon Repair LLC · Grundy Center, IAN4623JBrockway Jack E · Enumclaw, WAN4623ZCordell Ricky L · Fairfield, PAN46243Goracke Terry R · Junction City, ORN46245Fedor Allen L · Holdingford, MN
Back to AD 90-04-06 R1