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.
N84GGSweeney Jack R · Parker, AZN84GMCech Edward L · Grand Haven, MIN84GSAjluni Robert · Shreveport, LAN84HLLang Aviation Support Services LLC · Scottsdale, AZN84HWBerkbiegler Allen · Hardy, ARN84HXDriggers Group Inc · Saint Petersburg, FLN84HYH&A Aviation Lc · Hanover, VAN84JAAndre Joseph L · Puyallup, WAN84JDBeving Charles D · Garden City, SDN84JSKocak Robert G Jr · Peoria, AZN84KGGinz Peter M · Guilford, CTN84KTTaylor Kevin G · Mountain Grove, MON84LLLiebsch Mark · Reno, NVN84LPMinuteman Air Service Inc · Dewitt, ARN84MKNew Horizons Aviation Inc · Goshen, INN84MMEllison Phillip G · Castle Hayne, NCN84MSEdwards Bruce W · Palmer, AKN84NSale Reported · Eagle Point, ORSale reportedN84PTTackabury Jenny Ann · Santa Paula, CAN84RKJohnson Douglas L · Grass Valley, CAN84RLStockman Harold O · Elko, NVN84RMAugust Aero LLC · Kalispell, MTN84RPWellborn Michael Barrett · Broken Arrow, OKN84RWSleeman Weston H · Torrance, CAN84SAAshley Heating & Air · Wasilla, AKN84SFFifield Scott D · Overgaard, AZN84SKQuinlan John H · Claxton, GAN84TDBailey Dennis · Kernersville, NCN84TKRegistered aircraftN84TXBrooks Nathan · Manhattan, KSN84VCExperimental Flight Test Solutions LLC · Seattle, WAN84VHWeber David A · Snohomish, WAN84WDFortman James · Vancouver, WAN84WMErickson Lee A Trustee · Fargo, NDN84ZRomeo Aviation Ltd · East Sparta, OHN85007Sidell Joel R · Brighton, CON8500DScootair LLC · Alburgh, VTN8500QEilinger Richard L · Hertford, NCN8500UGlobal First Capital Aviation Group LLC · Amarillo, TXN8500ZKreilich Jonathan E · Rogerson, IDN8501DStrausser Brian J · Lower Burrell, PAN8501QLilly James E · Alamosa, CON8502DConrad Dylan · Randolph, WIN8502EJones Derick · Moultonborough, NHN8502FOrtiz John Pasqual III · Loma Linda, CAN8502VAngel Aviation Inc · Peoria, AZN8503Finney Michael E Trustee · Albany, INN8503CScites Robert W · Toney, ALN8503EB&B Aviation Holdings LLC · Pembroke Pines, FLN8503JClark T J · Saint George, UT
Back to AD 90-04-06 R1