AD 90-15-15 R1
Registered aircraft · 826
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-15-15-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-15-15-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-15-15-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-15-15-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.
N6FDScud Air 6fd LLC · Morgan, UTN700MGGeorgia Aviation Authority · Eastman, GAN702MGAmerican Champion Aircraft Corp · Rochester, WIN702NVAca Sd LLC · Kalispell, MTN7047CAerospace Trust Management LLC Trustee · Wilmington, DEN705RBYakubinis William J · Charlotte, NCN707GPIntermountain Air Inc · Colorado Springs, CON712KWing John David · Guymon, OKN715AMVon Graff Kurt · Pennington, NJN715USuper D Aviation LLC · Lafayette, ALN716ACAlexandrov Boyan · Reno, NVN717ACKcd Aviation LLC · Tonica, ILN717LVPage Wayne N · Corning, IAN719MWMel Williams Aviation LLC · Fairburn, GAN71BPPantaleo Robert · Vineland, NJN71SDRalph B Beatty LLC · Murrysville, PAN723CLVan Why Johnathan Ryan · Corvallis, ORN725CMScholz Mark W · Atchison, KSN725JMRegistered aircraftN726AWPhilbin Andrew Patrick · Cleveland, OHN727FWVoler Dans La Gloire LLC · Narberth, PAN727MRUnavex Inc · Pensacola, FLN72ARDollar Douglas A · Crawford, MSN72DCopenhaver Tracy K · Anthony, KSN72DLD Air LLC · The Colony, TXN731JDReifschneider Harry III · Mesa, AZN737ADDe Zafra Aaron · Mill Valley, CAN73JGMeyer Gordon W · Huber Heights, OHN73PAJones Brandon B · Saint Francisville, LAN73XDN73xd LLC · Houston, TXN743ACOlsson Charles E · West Point, VAN745MSSchamel Michael A · Salem, INN747GSMidwest Thermal Optics LLC · Walnut, ILN747LWOlhughes LLC · Staplehurst, NEN747PYPrivitt Bret J · Forest Hill, TXN748ACSweeet Aviation LLC · Dover, DEN749PCGreen Hornet Aviation LLC · Washington, DCN74CDMcburney & Associates LLC · Horseshoe Bay, TXN751UGaines Charles C · Fernandina Beach, FLN753RJMeyer Christopher R · Colchester, CTN754ACSunnypepper LLC · Old Hickory, TNN757ACLewis Aviation Inc · Wilmington, DEN757EJJames Marc Harry · Tryon, NCN75GKGrecor LLC · Ashville, ALN7621SSmith Michael D · King George, VAN7635SMcgaughy Robert E · Snow Hill, NCN7658SFlytwincos LLC · Las Vegas, NVN7671SKlos Aero LLC · Plevna, MTN7683SSzabolscky Stephen L · Remington, VAN7694SBaker Bruce A · Chandler, AZ
Back to AD 90-15-15 R1