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.
N8911DPunt Eric · Wasilla, AKN8911FA And J Aviation Services LLC · Titusville, FLN8911VHorizon Dreams LLC · Homer, GAN8912DParris Michael D · Rockport, TXFirst renewal noticeN8912JSoar With Sophia LLC · South Lyon, MIN8912VRoper Jeff A · Corralitos, CAN89132Affiliated Air Services Inc · Southampton, NJN8913CGuess Gerald B · Hernando, FLN8913DBrick H Paul · Pomerene, AZN8913FLay Jerry K · Minonk, ILN8913VI'Ll Fly Away LLC · Florence, SCN8914DPieper Michael D · Chandler, OKN8914JVesper Aviation LLC · Las Vegas, NVN8914RAgaliotis Paul E · San Martin, CAN8914YHarris William M · Christiansburg, VAN89159Napiecek Sarah · Kyle, TXN89168Hendrix Walter A · Monroe, GAN8916VTaylor William W Jr · Hudson Oaks, TXN8916YMyers Randall · Parshall, NDN89171Kruzdlo Alan · Calhoun, GAN8917JI Was Inverted LLC · Fort Myers, FLN8917YHigh Flyers Inc · Jackson, TNN89186Hangar 47 Aviation LLC · Midvale, UTN8918DPapalote Ranches LLC · Missoula, MTN8918RDoolittle Philip E · Dunmore, WVN8918YFerucci Paul G · Anchorage, AKN89192Stone Christopher B · High Point, NCN89197Campbell Michael R · Aurora, NEN8919DLuallin Randy D · Hot Springs, SDN8919JKelly Kevin R · Ormond Beach, FLN8919VChristiansen John · Vicksburg, MIN891DBSpivak Maxim · San Jose, CAN891DDDiehl James W · Williamsport, PAN891GPHancock Aircraft Sales LLC · Baton Rouge, LAN8920DReese Larry H · Raytown, MON8920JSargent Timothy E · Pickerington, OHN89215Delgado Ruben E · San Antonio, TXN8921DPetterson Jason G · Albert Lea, MNN8921RPotters Aviation LLC · Haskell, OKN8921VN2827n LLC · Pembroke Pines, FLN8922Culver Marc D · Anchorage, AKN89226Hillsboro Aero Academy LLC · Hillsboro, ORN8922DHassell Clark R · Ketchikan, AKN8922JTowner Jeffery D · Rose Hill, KSN8922VTampa Bay Aviation Inc · Clearwater, FLN8923Brockway Troy D · Salina, KSN8923DWood Rhonda R · Livermore, CAN8923JVenture West LLC · Mesa, AZN8924CHaines Delmar W · Rolla, MON8924DHickey Aero Services LLC · White Hills, AZ
Back to AD 90-04-06 R1