AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N3236XBentch James R · Lincoln, MON3237LKeith Investments LLC · Verona, MSN3237VTreetop Flying Circus LLC · Niceville, FLN3237XRobinson Michael D · Folkston, GAN3237YCopper Mountain Assets · Winthrop, WAN3238DLutes Richard L · Hampshire, ILN3238ESwiss Jack S · Anchorage, AKN3238JHolladay Harold · Lamesa, TXN3238XHorsager Phillip C · Montevideo, MNN3239DJaj Flying LLC · Sutton, NEN3239ELeaf Air LLC · Queensbury, NYN3239LGame Composites Flying Club · Bentonville, ARN3239Q92nd West Aviation Inc · Lonoke, ARN3239UJohnson Colten T · Richards, MON3239VMccue Michael R · Missoula, MTN3239YHarper Mark A · Winston Salem, NCN323ACKing Ag Leasing Inc · Sudan, TXN323DCFlymax Aircraft LLC · Ball Ground, GAN323FSFredericks Hall Aviation LLC · Mineral, VAN323KWBlue Cedar Aviation LLC · Raymore, MON323LULetourneau University · Longview, TXN323PCTriego Inc · Dumas, TXN323SMAmerican Patrols Inc · Midland, TXN323TJGuardian Wings LLC · Fredericksburg, VAN323TSKnippen Ronald M · Fort Jennings, OHN3240LWooden Alan L · Signal Mountain, TNN3240SBenson Richard T · Bend, ORN3240TFrena John A · Pittsburgh, PAN3240VAbston Alexandria P · Vancouver, WAN3241LDostroph Manfred J · Lewis Center, OHN3241TMaggart Daniel J · Winchester, ILN3241YNull James A III · Live Oak, TXN3242CPelski Aviation LLC · Ocala, FLN3242SBateman Amber · Elizabeth City, NCN3242TSt Clair Ronnie M · Cochise, AZN3242YShadow Air LLC · Norfork, ARN3243UGlobe Motorcycles Ltd Inc · Pembroke Pines, FLN3243XPowell Kenneth D · Benton, ARFirst renewal noticeN3244DBrooks Laura · Palmer, AKN3244LKyzer Aviation Holdings LLC · Fort Mill, SCN3244TCaicedo Oscar E · Garner, NCN3244XStecks Keith A · Vista, CAN3244YCutrell William J · Mc Donald, TNN3245GDougherty Robert E · Mosheim, TNN3245JAll Sports Aviation LLC · Spokane, WAN3245LGift Academy Inc · Vernon, TXN3245XSchneider Alex · Tempe, AZN3246DJaden H Erwin Dds Pllc · Helena, MTN3246EKauffman Gerald E · Bedford, PAN3246LStephens David J · Clarence, NY
Back to AD 97-01-13