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.
N7227JRad Aviation LLC · Abbeville, ALN7227KOlathe Spray Service Inc · Olathe, CON7227QElite Air LLC · Tullahoma, TNN7227YClearview Aerial Solutions LLC · Rogersville, TNN72282Merriam Paul · East Greenwich, RIN7228DAmigo Helicopter Services LLC · Falfurrias, TXN7228GFasking Dan · Stanford, ILN7228JRedhanded LLC · Dover, DEN7228ZHart Samuel C Jr · Newberry, SCN7229DBuergel Sandra J · East Aurora, NYN7229JLivingston Corey · Myrtle Beach, SCN7229NMccracken Donald D · Keyport, WAN7229QSwitzer Frank Jr · Port Allegany, PAN7229WRoll The Bones LLC · Kiln, MSN722AARobinson Charles F Jr · Portage, MIN722AKInternational Air Services Inc Trustee · Carson City, NVN722BMButler Francis J · Fargo, NDN722CSBoccaccio Peter Anthony · Burke, SDN722DBColaur LLC · Nashotah, WIFirst renewal noticeN722DCHiemstra Andrew Ralph Walter · Tuolumne, CAN722FLShaughnessy Thomas E · Seabrook, NHN722GACougar Ga-7 LLC · Helena, MTN722HAPerformance Sanitation Of Mississip · Deland, FLN722KJCraddock Kevin D · Clemson, SCN722KWBaker Scott · Chesterton, INN722MCClassic Banjo LLC · Richmond, KYN722MWRegistered aircraftN722NDUnd Aerospace Foundation · Grand Forks, NDN722PGFuller Jon A · Goliad, TXN722RReady Aim Flyer LLC · New Castle, DEN722RATotal Prf LLC · Lewes, DEN722RWRegistered aircraftN722SDGrove Bob · Boerne, TXN722SSWind Wizards Inc · El Paso, TXN722TIowa Aviation Heritage Museum · Ankeny, IAN722TCSchmitz William C · Charleston, SCN722WWeber Robert J · Manhattan, KSN722WMPegasus Enterprises LLC · Granbury, TXN7230FBenautics LLC · Wexford, PAN7230GMaples Kevin T · Pueblo, CON7230JBrewer Michael S · New Haven, WVN7230LLee Patrick G · Shawnee, KSN7230QArcade Flying Club Inc · El Dorado Hills, CAN7230YVyas Shiven P · Chino Hills, CAN7231JMcflight Aviation LLC · Highland, UTN7231KDengler Steven G · Lopez, WAN7231QDsr-Cherokee 180 LLC · Dallas, TXN7232CVector Aviation LLC · Mentor, OHN7232JEllero John L · Sun City, CAN7232WAwmr LLC · Conroe, TX
Back to AD 90-04-06 R1