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.
N7964NLoar Kenneth Joseph Jr · Mundelein, ILN7964WYambor Aaron Casimir · Bowling Green, OHN7965AGregory S Collins · Roxbury, NYN7965FLustig Barry J · San Ramon, CAN7965HBedard Michael J Trustee · Madison, ALN7965NArnold Milton E · Becket, MAN7966NWest Timothy A · Marion, KYN7966YAlbano Alan T · Elbert, CON7967CDeer Park Air Center LLC · Deer Park, WAN7967GWings Over Texas Holdings LLC · Denton, TXN7967NMorales Jesus L · San Antonio, TXN7967WTang Aviation LLC · Odessa, TXN7967YDodson International Parts Inc · Rantoul, KSN7968NLiebman Peter M · North Reading, MAN7968WLoser Eric S Sr · Millville, NJN7968YMustang Aeronautics LLC · Chandler, AZN7969GHealsburg Aviation · Healdsburg, CAN7969NJohnson Robert B · Murrieta, CAN7969WN7969w LLC · Reno, NVN796ABDrake Aerial Enterprises LLC DBA · Genoa, OHN796CPierobon Patricia · Port Orange, FLN796DBAnderson David E · Batesville, ARN796EPPrince Ellis C · Frierson, LAN796SBJones Dana C · Clermont, FLN796SPOpensky Airways LLC · Los Angeles, CAN796TMBlack John E · Cocoa Beach, FLN796TSSchlatterer William F Jr · Maumelle, ARN796WWCrist Aviation Services LLC · Woodland, CAN7970GAmerican Patrols Inc · Midland, TXN7970HMcneill Steven H · Santa Fe, NMN7970SNelson Dennis D · Salem, ORN7970WFly In Helicopters LLC · Florence, SCN7971FJanes Christopher D · Columbia, KYN7971NStalford Tom G · Nicholson, PAN7971YRegistration Pending · Collierville, TNRegistration pendingN7972CJust Plane People LLC · Irvine, CAN7972GMinot Aero Center · Minot, NDN7972HAerospace Trust Management LLC Trustee · Wilmington, DEN7972MRegistration Pending · Merrimack, NHRegistration pending, pending cancellationN7972VDionisio John · West Covina, CAN7972WLewis Paul A · Palm Bay, FLN7973HMessinger Donald C · Wasilla, AKN7973NN7973n LLC · East Greenville, PAN7974NKrumwiede Keith C · Rosedale, INN7974WAnderson Dale · Corona, CAN7974YHughes Frank H · Hackberry, LAN7975NKatz Alan D · Fayetteville, NCN7975WVilimek Mark W · Milpitas, CAN7976LFarrell Michael · Rockwall, TXN7976WWaldt Matthew C · Las Vegas, NV
Back to AD 90-04-06 R1