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.
N52669F Sharp Aviation LLC · New Baltimore, MIN5266DColemanation Investments LLC · Naperville, ILN5266ENatchez Flight Training LLC · Natchez, MSN5266HFritz Flying Service Inc · Lincoln, NEN5266KCorsicana Aviation Training Services LLC · Corsicana, TXN5266LIlmberger Stephen R · San Leandro, CAN5266SFogle Cooper · Mooresville, NCN5266UN5266u LLC · Brookfield, ILN5266WMichigan Sport Aviators Inc · Midland, MIN5266XKrabbenhoft J F · Amenia, NDN52671Carver Aero LLC · Muscatine, IAN5267EBrudelie Alan C · Lewisville, MNN5267LBlasi Aviation LLC · Valley Center, KSN5267PCarter Jeffrey Lee · Cameron Park, CAN5267XShelden Seth · Palmer, AKN52680Harris John Q · Tucson, AZN52683Cobb John Mark · Fayetteville, TNN52684Altair Advanced Industries Inc · Bellingham, WAN52685Glidewell Aviation Inc · Parkland, FLN5268BCabbage David A · Colville, WAN5268HGrander Aviation LLC · Panama City Beach, FLN5268JReach For Skies LLC · San Antonio, TXN5268KSorbi Aviation Inc · El Cajon, CAN5268RJohnson Steven D · Oklahoma City, OKN5268TDykes Don A · Houston, TXN52695Farley Ryan P · Cumberland, RIN52696Sladko Jeffrey · Battle Ground, WAN5269DGeorges Aviation Services Inc · Honolulu, HIN5269LKarel John · Stillwater, MNN5269TKailua Aviation LLC · Moorestown, NJN5269WGoetz David B · Gleason, WIN526AAPeregrine Howard Partners II Lp · New Orleans, LAN526BBBrookover James R · Hartville, OHN526BTAcme Aerosports Inc · Huntsville, ALN526CNJensen Michael S · Plano, TXN526DPAllaire Ernest · Groton, CTN526ECChapman Daniel W · Soldotna, AKN526EJNiles Jeffery F Jr · Clifton, MEN526FRoush Heith · Cabot, ARN526GCareer Pilot Training LLC · Wilmington, DEN526GGStocker Scott · North Las Vegas, NVN526GHCzajkowski Matthew A · Garfield, NJN526HBBarri Michael J · Burgaw, NCN526JSStephan Dwight M · Center Moriches, NYN526KGWalters David M · Wasilla, AKN526LDe Witt Luba Trustee · Fort Lauderdale, FLN526LWN526lw LLC · Salem, ORN526MABlue Sky Adventures LLC · Hanover, PAN526PDDecraene Peter R · Shorewood, ILN526SJCarter Shannon D · Englewood, CO
Back to AD 90-04-06 R1