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.
N4641QFitzsimons Nicholas T · Covington, LAN4641RWebb Patrick S · Chuckey, TNN4641ZZenisek Michael W · Fairfax, IAN46420Frontier Environmental Solutions Inc · Inyokern, CAN46423Parrish Aviation Flight Academy LLC · Southlake, TXN4642NCrouch Lynn DBA Highland Aviation · White House, TNN4642RSkyways Group LLC · Greensboro, NCN4642VBolster William L · Joshua Tree, CAN4642WHash Marshall W · Crumpler, NCN46430J & Dk LLC · Overland Park, KSN46433Plummer Fred C · Normal, ILN46435Hawkins County Sports Wings Inc · Kingsport, TNN46436Aero Science International LLC · Martinez, GAN46437Arizona Active Air LLC · Yuma, AZN46440Engelskirger Karl D · Valley City, OHN46442Lott Terence D · Florence, MSN46448Mac Air Inc · Farmington, MON46449Tilma Flying Club Inc · Moscow, IDN4644JWinslow Francis E III · Raleigh, NCN4644VHendricks Trenton Q · Bow, WAN4644YState Of Montana · Helena, MTN4645Ladage Terry L · Champaign, ILN46457Ostrowski Sven E · Mullica Hill, NJN4645JHitchcock Scott B · Waco, TXN4645RKunz Consulting Inc · Sun Prairie, WIN4645WClimb Maintain LLC · Morrisville, MON4646Bailey Christopher J · Riga, MIN46460Walter Timothy G · Farmersburg, IAN46462Cook Aviation Services LLC · Fargo, NDN4646JCulley Johnny C · Amarillo, TXN4646RWarren Global LLC · Chino, CAN4646VBaran Stephen · Littlestown, PAN46470Registration Pending · St Charles, ILRegistration pendingN46471Evergreen Avn Space Museum And Captain Michael · Mcminnville, ORN46473Aviation Capital Management LLC · San Jose, CAN4647QCowles Charles Orville · Mesa, AZN46484Campisteguy Alexander J · Renton, WAN46486Calimesa LLC · North Las Vegas, NVN46487Silver Express Co · Miami, FLN4648HLacore Justin Adam · Mckinney, TXN4648JTutt Bryan · Louisville, KYN4648MKaye Mykle · Wailuku, HIN46493Brown Michael F · Richford, NYN46495Hanna Douglas L · Winchester, KYN46497Tones Trucking Inc · Cassopolis, MIN4649MDaviation Inc · Willoughby, OHN4649QSkyhawk Services LLC · Lake Wales, FLN4649RHartley Zachary K · Dublin, GAN464BFMoore John W · Salome, AZN464CMUniversity Of Central Missouri · Warrensburg, MO
Back to AD 90-04-06 R1